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?
Answer Posted / abhishek.x.upadhyay
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 |
Post New Answer View All Answers
What is meant by incremental load?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
Explain do we need an etl tool? When do we go for the tools in the market?
What is lookup table in etl testing?
Can u access a repository created in previous version of Informatica?
what is pmrep command?
In Which Transformation We Can Use Having Clause In Informatica?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
How many steps etl contains?
what are the session parameters? How do u set them?
What is cube grouping?
how do u implement configuration management in Informatica?
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 your responsibilities as an etl tester?