- What is called as a surrogate key?
Surrogate key is a replacement for the natural primary key. It is an unique identifier and it can also be the no. of each row which can be used as the primary key.
- What are the differences between an unconnected lookup and connected lookup?
Connected lookup accepts input values straight from other transformations in the pipeline. The Unconnected one does not accept any inputs directly from any other transformation, however it can be used in any transformation and also can be invoked as a function by using the :LKP expression. So, an unconnected lookup can be called multiple times when in mapping.
- What are status codes?
Status codes are the ones which provide error handling for the informatica server during a session. The saved procedure creates a status code which notifies whether or not stored procedure will be completed successfully. This value cannot be seen by the user. It is only used by the informatica server only to determine if to continue running the session or to stop.
- How many types of dimensions are available in Informatica?
There are 3 types of dimensions available in informatica, they are :
- Junk dimension
- Conformed Dimension
- Degenerative Dimension
- What is called as the maplet?
It is a set of transformations that you develop in the maplet designer and it can be used in multiple mappings.
- What is the difference between Active and Passive transformation?
An Active Transformation can change the number of rows that pass through it from source to destination.
Meaning that it eliminates rows that do not meet the condition in transformation.
Passive Transformation does not change the number of rows that pass through it , that is it passes all rows through the transformation.
7.What is a command that used to run a batch?
pmcmd is used to start a batch.
- Define what is user-defined event?
It is nothing but a flow of tasks in the workflow process.These events can be created and raised as on when there is a need associated with it.
- What is Data Transformation Manager(DTM)?
After the load manager performs validations for the session, it creates the DTM process which is the second process associated with the session run.
- What are Rank transformation?
Rank transformation is an Active and Connected transformation which is used to select the top or bottom rank of data.
Get trained from the best IDQ trainers. For enrolling or for more informations on our courses and also on the upcoming IDQ batch. Please contact us.