Do you have to change the reject file b4 using reject loader utility.
Define Incremental Aggregation?
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
Which is costliest transformation? costly means occupying more memory?
How can one identify whether mapping is correct or not without connecting session?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
Clarify the utilization of aggregator cache record?
how many types transformations supported by sortedinput?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Describe an informatica powercenter?
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.