Explain the use lookup tables and Aggregate tables?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

Two different admin users created for repository are________and_________.

1 Answers  


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  


Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.

3 Answers   TCS,


Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


explain the methodology of Data Warehousing?(Polaries)

0 Answers  


how does the server recongnise the source and target databases.Elaborate on this

0 Answers   Accenture,


what is an ETL or ETT? And what are the different types?

0 Answers  


how would u estimate the size of Aggregator transform data and index cache?

0 Answers  


How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step

1 Answers  


Explain what are the various etl tools in the market?

0 Answers  


how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

0 Answers   Thomson,


Categories