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


Please Help Members By Posting Answers For Below Questions

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1636


Briefly define a session task?

586


Explian the Process of deployment groups in informatica

646


What do you understand by SOA of Informatica?

579


What are the different lookup cache(s)?

614






EXL informatica Questions

924


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

626


Different sorts of metadata that stores in the storage facility?

547


Can u generate reports in Informatica?

648


What are the types of caches in lookup? Explain them.

545


How do you load only null records into target? Explain through mapping flow.

1488


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9155


How can we use batches?

598


Why is sorter an active transformation?

657


What is informatica?

671