-
UNIX find, grep, sed
What is FIND, GREP and SED? Could you please give me the difference between all the three? Where we use this commnands?
-
Main data object in between Source and Target
What is the main data object present in between Source and Target.
-
Checksum and Pipeline
What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?
-
Dimensional modelling vs Data modelling vs ER modelling
What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.
-
Target Details Verification
If the records are transfered from Source to target and if you want to check whether all the records are stored in the target. What are the possible ways to check that.
-
Failed Workflow
When you run the sessions in a sequence what will happen when the first workflow fails and later you want to start with the second one and followed by others. Where will you do changes or necessary steps to run the workflow.
-
Session variables - what are they exactly
What are session variables and session parameters. Are the mapping variables and mapping parameters one and the same. I think it is not .
-
Run sessions
How do you run sessions one after another?
-
Joiner Transformation Master Detail
Suppose you have 2000 records in one table and 12000 in another which one you will consider as master and detail?
-
Transformation to Load 5 Flat files
What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?
-
Fact Table - Grain Facts
What are Grain Facts?
-
Mapping variable - Mapping Parameter
What will happen when Mapping variable and Mapping parameter in Informatica is not defined or given? Where do you use mapping variable and mapping parameter?