In joiner, how to load Master table in Target?

Answers were Sorted based on User's Feedback



In joiner, how to load Master table in Target?..

Answer / sandhya

detail outer is correct--keeps all the rows from master and
only matching rows from detail.for confirmation see join
types in joiner transformation designer guide

Is This Answer Correct ?    20 Yes 1 No

In joiner, how to load Master table in Target?..

Answer / sarvesh

just in joiner,go to join condition ,put the condition as
masteroutr join,then u get teh data of matched rows frm
both the tables and unmached rows from master table, tehn u
get the data of master table,then u connceted to tgt table.
this is all i guessing,if it is wrong correct me

Is This Answer Correct ?    0 Yes 10 No

Post New Answer

More Informatica Interview Questions

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,


Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  


wt is inline view? when and why we Use ?mail to rayallarv@gmail.com

2 Answers  


what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,






How to load last n records of file into target table - informatica

0 Answers   Informatica,


What is hash partition?

1 Answers  


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


How do you remove duplicate records in informatica?

1 Answers  


What are reusable transformations in how many ways we can create them?

2 Answers  


Do joiner transformation use cache? If so describe?

2 Answers   Patni,


What is the format of informatica objects in a repository?

0 Answers  


Categories