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 is tracing level?
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.
What is virtual Data Warehousing?
When do we analyze the tables?
what is the meaning of upgradation of Repository?
what are variable ports and list two situations when they can be used?
what are the data modeling tools you have used?(polaris)
What is factless fact schema?
my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
list and discuss two approaches for updation of target table in Informatica and how they are different.
What do you understand by active and passive transformations?
What is grain of fact?