Change Data Capture in Informatica,using Incremental
Aggregation.How can i identify the these data in Target
table.
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / amarnath
pass the records to the lokup transformation. u get a new
lookup port, pass this to router. in router 1st condition
newlookuprow =0 second newlookuprow =1. pass the "0" to
update strategy for update and pass the "1" to another
update strategy for insert.
Is This Answer Correct ? | 4 Yes | 4 No |
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Using Expression transformation how to remove duplicate records from a relational source?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
How are indexes created after completing the load process?
,if we have single SQ in flow and we have router in which it has two group and we want to join these two groups with joiner ?is it possible?
what is the difference between onsite & client site?
What is a joiner transformation?
What is a candidate key?
Explain the code page compatibility?
What are the Differences between static cache and dynamic cache?
What is option by which we can run all the sessions in a batch simultaneously?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer