Answer Posted / lalamaheshkumar
small correction for above ..
Hi for the above question you are going to get the suresh
record twice if you select rank as three (3) . to get the
distinct records , in source qualifier put a distinct
clause in the query .. then you will get the correct result.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
Under what condition selecting sorted input in aggregator may fail the session?
can u give example for factless fact table
What is the use of code page?
What is sq transformation?
explain about unit testing? in real time?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is the benefit of session partitioning?
Explain lookup transformation source types in informatica
What do you mean by blocking transformation?
Explain joiner transformation in informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
What is the Rank index port in Rank transformation?
How to do unit testing in informatica? How to load data in informatica ?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
