Interested to Buy Any Domain ? << Click Here >> for more details...
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 does command task mean?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the difference between stop and abort in informatica
Write the unconnected lookup syntax?
Please let me know how to make Data masking in informatica..
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain pushdown optimization and types in informatica
What is a difference between complete, stop and abort?
Difference between Data and Index Caches?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What are the different clients of powercenter?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are active and passive transformations?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
