Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8447 Views
- Fidelity, I also Faced
- E-Mail Answers
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 an unconnected transformation?
What is data movement mode in Informatica and difference between them?
What are the types of schemas we have in data warehouse.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to delete duplicate row using informatica?
How identifying bottlenecks in various components of informatica and resolving them?
What do you mean by filter transformation?
What are the performance considerations when working with aggregator transformation?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is dimensional table? Explain the different dimensions.
How we can use union transformation?
Can you generate sequence numbers without using the sequence generator transformation?
Implementation methodology
Differentiate between source qualifier and filter transformation?
Clarify the utilization of aggregator cache record?
