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 |
Define filter transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is fact table? Explain the different kinds of facts.
What is the difference between writing a joiner query in ANSI style and THETA style?
can you please explain me pre session and post session options?
What is galaxy shema
What are the new features of informatica 9.x developer?
my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.
What is the advantage of informatica?
What is the difference between informatics 7x and 8x and what is latest version?
Can we insert ,update ,delete in target tables with one update strategy tran.?
what is data driven in update strategy transformation?