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



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..

Answer / rajendra kommineni

WE CAN USE SCD TYPE1
i.e BY USING UPDATE STATERGY

Is This Answer Correct ?    7 Yes 1 No

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..

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

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..

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

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..

Answer / abhinaw prakash

We can use Update strateGY TO execute the following scenario

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  


how to delete duplicate records by using filter transfermation?

3 Answers  


Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,


What can we do to improve the performance of informatica aggregator transformation?

0 Answers  


What are the different threads in DTM process?

2 Answers  






what we require for D.modelling?

1 Answers  


Briefly explain the aggregator transformation?

0 Answers  


difference between repository database and repository service?

0 Answers  


Explain pushdown optimization and types in informatica

0 Answers   Informatica,


differences between service based and product based?

0 Answers   Satyam,


By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,


I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .

2 Answers   CTS,


Categories