What are the basic requirements to join two sources in a source qualifier transformation using default join?


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

Post New Answer

More Informatica Interview Questions

What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  


How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??

1 Answers   KPIT,


what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

2 Answers   CGI,






Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


What are the different types of Type2 dimension maping?

2 Answers   CTS,


What is a difference between complete, stop and abort?

0 Answers  


if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,


what is mapping override?

2 Answers   Cap Gemini,


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

1 Answers   CGI,


Why sorter is an active transformation?

0 Answers   Informatica,


Categories