Answer Posted / lahari
There are multiple ways to do it.
1.if source is RDBMS then we can filter by selecting distinct option.
2.In sorter transformation select distinct.
3.In Aggregator transformation select all ports as group by key.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we can use union transformation?
can anyone suggest best free Talend data integration training online
How do you migrate data from one environment to another?
Can we override a native sql query within informatica?
Can we get 1st record through Informatica(without sequence number).
What are the main features of Oracle 8i with context to datawarehouse?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
State the differences between sql override and lookup override?
have u done any performance tuning? how u ll do?
how to load rows into fact table in data warehouse
What is the Process to creating lookup transformation in informatica
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are ETL Tools?
What are junk dimensions?
What are connected or unconnected transformations?