Interested to Buy Any Domain ? << Click Here >> for more details...
In joiner, how to load Master table in Target?
- 2 Answers
- 7893 Views
- I also Faced
- E-Mail Answers
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 |
what is the size of your data warehousing?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
Explain joiner transformation in informatica
What are the data movement modes in informatica?
Explain scd type 3 through mapping.
Types of error logs in Informatica?
How to delete duplicate records in a flat file source?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
If I have a index defined on target table and if set it to bulk load will it work ?
What is meant by lookup transformation?
What is a joiner transformation and why it is an active one?
Teradata 
