In joiner, how to load Master table in Target?
Answers were Sorted based on User's Feedback
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 |
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 |
suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer
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)?
Router T/R is active but some people are saying it is also passive which is exactly right?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
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
What is hash partition?
Stage is which type of load is it a full load or incremental load Please let me know in detail with best example
How do you remove duplicate records in informatica?
What are reusable transformations in how many ways we can create them?
Do joiner transformation use cache? If so describe?
What is the format of informatica objects in a repository?