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?
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 |
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
What is ROWID explain ?
what do u do when DB time takes more?in sap bi
Explain the key challenges that you face while performing etl testing.
indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain do we need an etl tool?
tell me few points when u become TL
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Explain about power designer data modeling software?
How to fine tune mappings?
Explain what is etl process? How many steps etl contains explain with example?