1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

Hi All, i have question regarding Change Data Capture in
Informatica. As i know we can do this using Incremental
Aggregation(i never worked on Informatica but i read) and i
think we can do the same with SQL Over write and with
variables. Can someone tell me how do we do this using
other two techniques.. using SQL Over write and variables.

Thanks for the help and greatly appreciated.

Question Posted / krishraj


Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this usi..

Answer / rajesh_audhi

If u have audit columns in the source like load_date we can
easily captured the changed data.we will extract only
changed data thru a query override in source qualifier by
giving like load_date>$$load_date.$$load_date is a mapping
variable which we set this value to the max(load_date)
during run time of session.so that it will store
max(load_date) in the variable and next time when we run the
same mapping it will fetch the source rows based on the
condition load_date>$$load_date.we will set this $$load_date
to max value using setmaxvalue function in any expression
transformation.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More Informatica Interview Questions

Different types of Power center errors?

1 Answers   Cinterco, IBM,

Why update strategy and union transformations are active? Explain with examples.

0 Answers  

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  

What is olap (on-line analytical processing?

0 Answers  




What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

SO many times i saw "$PM parser error " .what is meant by PM?

1 Answers  

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 Answers  

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

Hi experts ,I have a Source of 1000 records.I have to load 100 records in first target,101 to 200 records in 2nd target, 201 to 300 records in 3rd target and again 301 to 400 in first target like that as cyclick process. How can i acheive this.

5 Answers   DELL, TCS,

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

What is Micro Strategy? Why is it used for?

5 Answers   Infosys,

For more Informatica Interview Questions Click Here
Categories