Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
Answer Posted / rajasekhar.
we can create a parameter file as previous_run_time and
current_run_time in the mapping. based on this time stamps
we can capture the new records which need to be insert and
update in the target table.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Define pmcmd command?
What is the difference between stop and abort in informatica
What are the main features of Oracle 8i with context to datawarehouse?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Explain what are the different versions of informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Which are the different editions of informatica powercenter that are available?
What is a router transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is meant by lookup transformation? Explain the types of lookup transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the difference between a connected look up and unconnected lookup?
Enlist the differences between database and data warehouse.
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is blocking transformation?