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
- 7082 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How can you validate all mappings in the repository simultaneously?
How many types of sessions are there in informatica.please explain them?
Define sessions in informatica etl?
What are the types of caches in lookup? Explain them.
What is a repository? And how to add it in an informatica client?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How does a rank transform differ from aggregator transform functions max and min?
Can anyone tell me the new features in Informatica 9 Version?
What do mean by local and global repository?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the procedure for creating independent data marts from informatica 7.1?
In which transformation you cannot drag ports into it?
What is the meaning of up gradation of repository?
what are the deliverables?in your project?
