What is a design?
what is incremental data aggregation?
What is power center repository?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
what is row level and column level indicator?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
How to improve the session performance in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b,the target shd be loaded as 1 a+b+c or 1 a||b||c, what transformations shd be used for this?
How to delete the (flat file) data in the target table after loaded.
how many ways can we implement SCD2?
Explain informatica architecture - version 8 / 9
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files