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 |
What are the three tiers in etl?
how to answer the question "explain project architecture" in informatica pls any one who has the answer pls send the answer to this mail id "karumanchisrinu@gmail.com
what is the difference between cubes and package in cognos
What are the different Lookup methods used in Informatica?
how do u extract data from different data sources explain with an example?
How can we handle Rejection Logic in Source tables while we are matching the data in Target side in ETL Testing ?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u set partition points in the mapping?
Can there be sub steps of etl steps?
List few etl bugs?
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?
what is the difference between OLTP database and data warehousing database?