Interested to Buy Any Domain ? << Click Here >> for more details...
In joiner, how to load Master table in Target?
- 2 Answers
- 7961 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 |
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
Why is meant by direct and indirect loading options in sessions?
What is an active transformation?
how to load rows into fact table in data warehouse
what are the Methods For Creating Reusable Transformations?
What are the main issues while working with flat files as source and as targets ?
Design time, run time. If you don't create parameter what will happen
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?
why sequence generator should not directly connected to joiner transformation ?
Teradata 
