| Other Informatica Interview Questions |
|| Asked @
|What is the difference Between Mapping parameter and variable
|Difference Between ETL & ELT?
|how to calculate the optimum cache size in aggregator
|My source has 100 records. I have targets say in number 5.
all target tables has parent and child relationships in
between themselves. Now I want to load all 100 records into
all targets. How U can ensure that record inserted in parent
and then loaded into child.
|If I have a index defined on target table and if set it to
bulk load will it work ?
|What is the Router transformation?
|we have a parameter file in Unix location where we
have .txt files and those file will be used as source in
I cannot use source file name directly as file name will
keep on changing in unix location.
I need to define $$InputFile as parameter.
Can anybody send me the parameter file and the steps to
|what are the reusable tasks in informatica ?
|what is the purpose of surrogate key and diff between primary
|How to identify this row for insert and this row for update
in dynamic lookup cache
|What are slowly changing dimensions?
|What is the need of building a data warehouse?
|For more Informatica Interview Questions Click Here |