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?
Answer Posted / abhishek.x.upadhyay
In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are the key benefits of ETL Testing?
State the differences between shortcut and reusable transformation
Explain me ETL project architecture in Detail?
What do you understand by the term ‘transformation’?
What do you understand by active and passive transformations?
how to load the data to fact table?
Explain about hash partitioning?
Explain different types of partitioning?
what is session partitioning?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what is Forward,Reverse and Re_engineering?
What is a mapping, session, worklet, workflow, mapplet?
When do we analyze the tables? How do we do it?
Is hadoop a etl tool?
What is cube grouping?