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 |
Explain what are the various etl tools in the market?
What is etl process. How many steps etl contains explain with example?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
what is data modeling?
how does the server recongnise the source and target databases.Elaborate on this
What are materialized views & where do we use them?
what are the data modeling tools you have used?(polaris)
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
What are the types of Data Warehouse applications?
Can u access a repository created in previous version of Informatica?
Explain about round-robi?
How many steps etl contains?