How to update or delete the rows in a target, which do not have key fields?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

How do you do error handling in Informatica?

1 Answers  


Explain constraint based loading in informatica

0 Answers   Informatica,


there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,


I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,


What is flashback table ? Advance thanks

0 Answers   Puma,






in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,


How will u find weather dimension table is big in size of a fact table?

1 Answers  


How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,


Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  


I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  


Can i create a lookup table without cache.

7 Answers   iGate,


What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,


Categories