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
Mention few test cases and explain them?
What is partitioning? Explain about round-robin, hash partitioning.
How to fine tune mappings?
How many steps etl contains explain with example?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
how many steps are there in etl process?
How to delete data which is not in source table?
Explain about power designer data modeling software?
can cubes contain measures ?
how many maximum session supports to multiload in teradata ??
how do u really know that paging to disk is happening while u are using a lookup transform?
what are the cubes developed in a sap bw project and what is the requirement for developing it?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
where is the cache (lookup, index) created and how can you see it.
Compare etl & elt?