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

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 are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,


h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,


what is incremental data aggregation?

3 Answers   IBM,


What is Session and Batches?

0 Answers   Informatica,


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

0 Answers  


we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,


if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  


i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,


Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,


scd methodology?

2 Answers  


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers  


Categories