can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
How many types of transformations supported by sorted input?
What are the key benefits of ETL Testing?
What do you understand by the term ‘transformation’?
what are the production issues in datastage?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Explain the use lookup tables and Aggregate tables?
what are the different Reporting and ETL tools available in the market?
how many steps are there in etl process?
Compare etl & elt?
I have a Flat file with more no. of Records also including duplicate values. But i need distinct values to one target and remaining records to another target in Informatica way
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is the difference between OLTP database and data warehousing database?