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
Do we need an etl tool?
What are materialized views & where do we use them?
Explain me ETL project architecture in Detail?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
What is the difference between round-robin partitioning and hash partitioning?
What is tracing level?
What are dimensions?
What is etl process. How many steps etl contains explain with example?
where is the cache (lookup, index) created and how can you see it.
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com
what happens if the info.server doesn't find the session parameter in the parameter file?
State the differences between shortcut and reusable transformation
how do use session mapping parameters ?(in which transformation)
what are the concerns of OLTP and DSS systems?
What do you understand by active and passive transformations?