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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Enlist the differences between database and data warehouse.
Is there any target staging area in informatica not staging area
To import the flat file definition into the designer where should the flat file be placed?
What is domain in terms of informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How to do the error handling of if ur source is flatfiles?
What is the sql query overwrite in source qualifier in informatica
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is a dimensional model?
how to create user defined function (udf) in informatica
What could be the possible resons of locks by user?
What is session task and command task?
What if the source is a flat-file?
How to go to the older version for a mapping?