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
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Define joiner transformation?
What is the difference between a connected look up and unconnected lookup?
What are the different types of olap? Give an example?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What are the basic requirements to join two sources in a source qualifier transformation using default join?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
How many ways are there to create ports?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the restrictions of union transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the types of caches in lookup? Explain them.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the sql query overwrite in source qualifier in informatica