Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 7006 Views
- I also Faced
- E-Mail Answers
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 |
Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve
Differentiate between a repository server and a powerhouse?
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What is CHECK-IN CHECK-OUT. Please explane me?
In a concurrent batch if a session fails, can you start again from that session
HOW TO DELETE A RECORD FROM FLAT FILE
What is operational data source (ODS)?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What is union transformation?
What are Rapid changing dimensions?
What are the out put files that the informatica server creates during the session running?
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
Teradata 
