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 |
Differentiate between a database and data warehouse?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the different caches used in informatica?
Why we use partitioning the session in informatica?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
what is the Default Source Option For Update Strategy Transformation?
Any one can tell me how to explain puss-down optimization ? explain me with example plz?
Why is meant by direct and indirect loading options in sessions?
how to load dimension table and fact table. plz tell me the steps.
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
What do you mean by enterprise data warehousing?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?