Define the various join types of joiner transformation?


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

Post New Answer

More Informatica Interview Questions

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,


What is version control in informatica ? Advance thanks

6 Answers   HCL, Puma,


How do you migrate data from one environment to another?

0 Answers  


hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,






if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,


Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  


How to recover sessions in concurrent batches?

1 Answers  


How to enter same record twice in the target table,explain?

7 Answers  


Hi Friends, I want lo truncate my records from target before loading current month data,but i dont have permission to truncate with truncate option if u know any other way please give your valuable input for this. Thanks Abhishek

5 Answers   CSC,


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

0 Answers  


SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?

6 Answers   IBM,


Categories