Interested to Buy Any Domain ? << Click Here >> for more details...
In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
- 2 Answers
- 11824 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 |
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
what is index?how it can work in informatica
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
which transformation uses cache?
What is informatica? What exactly are the practical uses in real world
TELL ME ABOUT WORK FLOW SCHEDULING?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Why filter transformation is an active one?
How do you manage the Parameter files while migrating your data from one environment to another environment?
can we generate reports in informatica ? How?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
Teradata 
