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
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 |
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Why use shortcuts(Instead of making copies).
What is source qualifier transformation in informatica?
Mention a few design and development best practices for informatica?
What are the ETL tools available in DWH?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
Why we select the table which has minimum number of records as Master table in joiner?
what is the function of 'F10' informatica ?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance