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
- 8588 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
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 Default Source Option For Update Strategy Transformation?
What does update strategy mean, and what are the different option of it?
Explain the tuning lookup transformation - informatica
How to go to the older version for a mapping?
what is mean by complex business rule ?
State the limitations where we cannot use joiner in the mapping pipeline?
what are 3 tech challenges/ common issues you face?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How many numbers of sessions can one group in batches?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Where can we find the throughput option in informatica?
How to differentiate between the active and passive transformations?
COM components can be used in Informatica
What are the different clients of powercenter?
