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
- 8616 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
Why filter transformation is an active one?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What are the main features of Oracle 8i with context to datawarehouse?
Describe expression transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
What is the scenario which compels informatica server to reject files?
Write the unconnected lookup syntax?
What is rank transformation in informatica
How to load a Dimension ? and how to load a fact table?
Informatica Checkpoints
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is sq transformation?
