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

where we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  


How we can see table structure?

2 Answers   iGate,


what is Forward,Reverse and Re_engineering?

0 Answers   QualTech,


when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  


SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,






how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  


What is a lookup table in etl?

0 Answers  


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

0 Answers  


Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,


what is the difference between normal & bulk loading? and which one is recommended ? why?

2 Answers  


can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  


what are Lookup caches options? Including persistent caches.

0 Answers  


Categories