Answer Posted / lalamaheshkumar
Hi for the above question you are going to get the suresh
record twice if you select rank as two (2) . 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 ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is workflow monitor?
Explain the mapping variable usage example in informatica
What is a repository manager?
Differentiate between a database and data warehouse?
How we can use union transformation?
Write the advantages of partitioning a session?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Target increases every day even though no new record was inserted
Explain the code page compatibility?
What do you understand by a term domain?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Explain the tuning lookup transformation - informatica
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Describe expression transformation?
What is an Integration service in Informatica?