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
How can you define user defied event?
What are mapplets? How is it different from a Reusable Transformation?
write a query to retrieve the latest records from the table sorted by version(scd)
Differentiate between joiner and lookup transformation?
What is fact table? Explain the different kinds of facts.
What is the difference between informatica 7.0 and 8.0?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the use of an aggregator cache file?
How to delete duplicate row using informatica?
where to store informatica rejected data? How to extract the informatica rejected data?
What are the components of workflow manager?
Please let me know how to make encryption and decryption with example?
Why update strategy and union transformations are active?
Which is the t/r that builts only single cache memory?
What is a transaction control transformation?