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
if i have a query as flat file how can we load data to target table
what is Forward,Reverse and Re_engineering?
what is the use of server?
what is session partitioning?
How many steps etl contains?
What is etl process?
Explain about hash partitioning?
what is the use of structures?how many nodes can u create in a structure?
What is a lookup table in etl?
What is grain of fact?
What is the difference between round-robin partitioning and hash partitioning?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
can cubes contain measures ?
where is the cache (lookup, index) created and how can you see it.
What is fact? What are the types of facts?