In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
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 we can load rejected record's at run time?(not through bad files)
What is the filename which you need to configure in UNIX while installing infromatica?
Issue with Update override at Target table in Informatica.
Explain the use of aggregator cache file?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
What are the session parameters?
Can we update the data in flat file using update strategy?
what is rank and dense rank in informatica with any examples and give sql query for this both ranks
Under what conditions selecting sorted input in aggregator will still not boost session performance?
How to create or import flat file definition in to the warehouse designer?
What is a surrogate key?Why we use it in a mapping?Pl give an example.
can anyone explain me about retail domain project in informatica?