Using Expression transformation how to remove duplicate
records from a relational source?
Answer Posted / infabee
Expression is a passive transformation. So we can't delete
any row in it. We can achive only by using an active
transformation with/without it (SQ,Filter,Agg..etc).
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Plz can any one say me how to get the informatica certification materials and dumps
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Difference between Target-based loading and constraint-based loading?
What you know about transaction control transformation?
expain about the tune parameters?
What is a filter transformation and why it is an active one?
Write the prerequisite tasks to achieve the session partition?
What is decode in informatica?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What are the uses of etl tools?
How to improve the performance of a session using sorter transformation?
What is sequence generator transformation in informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain the difference between a data warehouse and a data mart?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?