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 |
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
Explian the connected and unconnected lookup transformation
update strategy transformation in informatica
Define error Threshold?
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Implementation methodology
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,