informaticafaq-5
1.While importing the relational source defintion from database,what are the meta data of source U import?
Source name
Database location
Column names
Datatypes
Key constraints
2. Howmany ways U can update a relational source defintion and what r they?
Two ways
1. Edit the definition
2. Reimport the defintion
3.Where should U place the flat file to import the flat file defintion to the designer?
Place it in local folder
4. To provide support for Mainframes source data,which files r used as a source definitions?
COBOL files
5. Which transformation should u need while using the cobol sources as source defintions?
Normalizer transformaiton which is used to normalize the data.Since cobol sources r oftenly consists of Denormailzed data.
6. How can U create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat file.When the informatica server runs the session,it creates and loads the flatfile.
7.What is the maplet? Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.
8. what is a transforamation? It is a repostitory object that generates,modifies or passes data.
9. What r the designer tools for creating tranformations?
Mapping designer
Tansformation developer
Mapplet designer
10. What r the active and passive transforamtions?
An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.
11. What r the connected or unconnected transforamations?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.
12. How many ways u create ports?
Two ways
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.
14. What r the reusable transforamtions?
Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances automatically reflect these changes.This feature can save U great deal of work.
15. What r the methods for creating reusable transforamtions?
Two methods
1.Design it in the transformation developer.
2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation.
Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time.
If u change the properties of a reusable transformation in mapping,U can revert it to the original reusable transformation properties by clicking the revert button.
16.What r the unsupported repository objects for a mapplet?
COBOL source definition
Joiner transformations
Normalizer transformations
Non reusable sequence generator transformations.
Pre or post session stored procedures
Target defintions
Power mart 3.5 style Look Up functions
XML source definitions
IBM MQ source defintions
17. What r the mapping paramaters and maping variables?
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session.
When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session.
Unlike a mapping parameter,a maping variable represents a value that can change throughout the session.The informatica server saves the value of maping variable to the repository at the end of session run and uses that value next time U run the session.
18. Can U use the maping parameters or variables created in one maping into another maping? NO.
We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.
19.Can u use the maping parameters or variables created in one maping into any other reusable transformation?
Yes.Because reusable tranformation is not contained with any maplet or maping.
Source name
Database location
Column names
Datatypes
Key constraints
2. Howmany ways U can update a relational source defintion and what r they?
Two ways
1. Edit the definition
2. Reimport the defintion
3.Where should U place the flat file to import the flat file defintion to the designer?
Place it in local folder
4. To provide support for Mainframes source data,which files r used as a source definitions?
COBOL files
5. Which transformation should u need while using the cobol sources as source defintions?
Normalizer transformaiton which is used to normalize the data.Since cobol sources r oftenly consists of Denormailzed data.
6. How can U create or import flat file definition in to the warehouse designer?
U can not create or import flat file defintion in to warehouse designer directly.Instead U must analyze the file in source analyzer,then drag it into the warehouse designer.When U drag the flat file source defintion into warehouse desginer workspace,the warehouse designer creates a relational target defintion not a file defintion.If u want to load to a file,configure the session to write to a flat file.When the informatica server runs the session,it creates and loads the flatfile.
7.What is the maplet? Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.
8. what is a transforamation? It is a repostitory object that generates,modifies or passes data.
9. What r the designer tools for creating tranformations?
Mapping designer
Tansformation developer
Mapplet designer
10. What r the active and passive transforamtions?
An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.
11. What r the connected or unconnected transforamations?
An unconnected transforamtion is not connected to other transformations in the mapping.Connected transforamation is connected to other transforamtions in the mapping.
12. How many ways u create ports?
Two ways
1.Drag the port from another transforamtion
2.Click the add buttion on the ports tab.
14. What r the reusable transforamtions?
Reusable transformations can be used in multiple mappings.When u need to incorporate this transformation into maping,U add an instance of it to maping.Later if U change the definition of the transformation ,all instances of it inherit the changes.Since the instance of reusable transforamation is a pointer to that transforamtion,U can change the transforamation in the transformation developer,its instances automatically reflect these changes.This feature can save U great deal of work.
15. What r the methods for creating reusable transforamtions?
Two methods
1.Design it in the transformation developer.
2.Promote a standard transformation from the mapping designer.After U add a transformation to the mapping , U can promote it to the status of reusable transformation.
Once U promote a standard transformation to reusable status,U can demote it to a standard transformation at any time.
If u change the properties of a reusable transformation in mapping,U can revert it to the original reusable transformation properties by clicking the revert button.
16.What r the unsupported repository objects for a mapplet?
COBOL source definition
Joiner transformations
Normalizer transformations
Non reusable sequence generator transformations.
Pre or post session stored procedures
Target defintions
Power mart 3.5 style Look Up functions
XML source definitions
IBM MQ source defintions
17. What r the mapping paramaters and maping variables?
Maping parameter represents a constant value that U can define before running a session.A mapping parameter retains the same value throughout the entire session.
When u use the maping parameter ,U declare and use the parameter in a maping or maplet.Then define the value of parameter in a parameter file for the session.
Unlike a mapping parameter,a maping variable represents a value that can change throughout the session.The informatica server saves the value of maping variable to the repository at the end of session run and uses that value next time U run the session.
18. Can U use the maping parameters or variables created in one maping into another maping? NO.
We can use mapping parameters or variables in any transformation of the same maping or mapplet in which U have created maping parameters or variables.
19.Can u use the maping parameters or variables created in one maping into any other reusable transformation?
Yes.Because reusable tranformation is not contained with any maplet or maping.
posted by dwhfaq | 10:57 AM
0 Comments:
Post a Comment
<< Home