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 will the document be delivered to me?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How to convert multiple rows to single row (multiple columns) in informatica
What are the designer tools for creating transformations?
How are the sources and targets definitions imported in informatica designer?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Is there any way to read the ms excel datas directly into informatica?
How to call shell scripts from informatica?
What do you understand by a term domain?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Which are the different editions of informatica powercenter that are available?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How to use procedural logic inside infromatica?
How many ways are there to do 'remove duplicate records in informatica'?
How might you approve all mappings in the archive all the while?
