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
- 8593 Views
- Fidelity, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajendra kommineni
WE CAN USE SCD TYPE1
i.e BY USING UPDATE STATERGY
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / arpit
For this a SCD type2 mapping has to be created which will handle both update and insert. This mapping will be having 2 target instances i.e. one instance for updating and other is for inserting records. Use router to divide the rows in two groups i.e. update and insert. In the pipeline for update target instance use the update strategy transformation for update.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / 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 |
Answer / abhinaw prakash
We can use Update strateGY TO execute the following scenario
| Is This Answer Correct ? | 0 Yes | 0 No |
what is difference between dimention table and fact table?
What is data transformation manager process?
Whats the difference between informatica powercenter server, repositoryserver and repository?
If the records doesnt satisfy the filter condition where will it go?
How is Data Models Used in Practice?
What are Rapid changing dimensions?
What is dimensional table? Explain the different dimensions.
What happens if the info. Server doesn't find the session parameter in the parameter file?
How you count the number of records available at your source?
how we can update a target table without update strategy and update override?
Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution
What are the Advantages of de normalized data?
Teradata 
