In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
- 2 Answers
- 10667 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priyank
Its completely on a developer's discretion to decide which
source would be the master and which would be the detail.
Generally keeping in mind the performance factor, we tend to
make the source with less number of ports as the master.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / naidu+.k
In Joiner Transformation it maintains two sources master and
detail source.Matser Source contains less number of Records
and its supports conditional values and detail source is an
output values stores.
| Is This Answer Correct ? | 9 Yes | 4 No |
delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses
What are data-driven sessions?
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Make a note of the quantity vaults made in informatica?
can we use mapplet as starting n ending object in mapping
What are the main issues while working with flat files as source and as targets ?
what are 3 tech challenges/ common issues you face?
What are the components of workflow manager?
Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
daily how much amount of data send to production?
How to extract sap data using informatica?
Teradata 
