whats the option in informatica 7 version is outdated in
informatica 8 version onwards.
Explain the use of aggregator cache file?
HOW TO YOU LOAD TIME DIMENSION
What is surrogate key?
What are session parameters ? How do you set them?
what is incremantal aggregation?
Difference Between ETL & ELT?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
what is the size of your data warehousing?
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's the layout of parameter file (what does a parameter file contain?)?
What is update override?
explain abt union t/r?