on a day i load 10 rows in my target and on nextday i get
10 more rows add to my target but out of 5 are update row
how ican send them to target?how i can insert and update
the records
Answer Posted / jaspreet banga
For This we Have to Use Job Control table(JCT), JCT is used
to select only those records which are provided next day
and then in mapping :---
1.) In source Qualifier write a pre sql query to read only
those record which are provided previous day, ]
2.)In router Route the data for update and insert.
3.) Use 2 update strategies i.e.., one for updating
existing record and other for inserting new one.
(Type-1 SCD) if you dont want to preserve the history.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is Active lock explain
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is mapplet in informatica?
How do you use reject loader.
Explain pushdown optimization and types in informatica
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is a passive transformation?
What is the use of an aggregator cache file?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to extract the informatica rejected data?
What is lookup transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
How to differentiate between the active and passive transformations?
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
Can we override a native sql query within informatica?