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?
- 1 Answers
- 3792 Views
- I also Faced
- E-Mail Answers
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 |
can cubes contain measures ?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
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 are the parts of Informatica server ?
what is SMP AND MPP?
Difference between flat files and relational sources?
How to load Session Statistics (Workflow name, TgtRows, Rejected Rows, SessStartTime,SessEndTime..)into a database table ?? Another Question: I want to pass values from oracle table or Flat file in Mapping parameter/Variable.. What is the method for that..Please provide me the solution step by step
What are various etl tools in the market?
how would u estimate the size of Lookup transform data and index cache?
What are the different Lookup methods used in Informatica?
what is session partitioning?
What is lookup table in etl testing?
Teradata 
