Answer Posted / 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 View All Answers
What are the restrictions of union transformation?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is rank index in rank transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How can we update a record in the target table without using update strategy?
Explain what are the different versions of informatica?
Differentiate between Load Manager and DTM?
What is the cumulative sum and moving sum?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
scenario where i can use only concurrent execution of workflow.
How many ways are there to create ports?
How do you migrate data from one environment to another?
On which transformations you created partitions in your project?
what is the size of your data warehousing?