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

What is informatica metadata and where is it stored?

780


Differentiate between joiner and lookup transformation?

867


What is a sequence generator transformation?

789


Difference between Target-based loading and constraint-based loading?

767


what are 3 tech challenges/ common issues you face?

2125


What is a shortcut and copy in Informatica and how two are different with each other?

945


What is the use of an aggregator cache file?

927


How to Create a folder using pmrep command?

854


How to join three sources using joiner? Explain though mapping flow.

909


How to generate sequence numbers?

832


How are the sources and targets definitions imported in informatica designer?

882


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1723


What is Data Caches size?

847


How many numbers of sessions can one group in batches?

835


What is meant by query override?

843