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

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

0 Answers  


What is the difference between procedure and stored procedur?

2 Answers   IBM,


What do think which one is the better joiner or look up?

0 Answers  


Define mapplet?

0 Answers  


How to differentiate between the active and passive transformations?

0 Answers  






My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,


how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,


what is mapping performence?

2 Answers   Cap Gemini,


What are the designer tools for creating tranformations?

1 Answers   Informatica,


why we use informatica in our project?

2 Answers   TCS,


Categories