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
- 8427 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
tell me the rules and responsblites in our project(my project is development)
Explain pmcmd command usage in informatica
What do you mean by filter transformation?
How do you load first and last records into target table?
Have you worked with/created Parameter file
What is sequence generator transformation in informatica?
What is powercenter on grid?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
In informatica workflow manager, how many repositories can be created?
How to configure mapping in informatica?
Separate from an archive server and a powerhouse?
How might one distinguish in the case of mapping is right or not without associating session?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to extract the informatica rejected data?
What is the meaning of decode in informatica?
