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 is the use of server manager?
How can we use external procedural logic in informatica?
List few etl bugs?
when will use SQL override in a lookup transformation?
what is dynamic insert?
how would u estimate the size of Aggregator transform data and index cache?
Explain do we need an etl tool?
What is Data Vault???
Do we need an etl tool?
Which transformation we use to convert 'NA' to 'Not Available'
Explain etl?
What are materialized views & where do we use them?
Explain the key challenges that you face while performing etl testing.
What is tracing level? How many types of transformations supported by sorted input?
Can there be sub steps of etl steps?