how to delete duplicate records by using filter
transfermation?
Answer Posted / devendar pd
if we use group by key columns in aggrigator then automatically duplicates will be removed, no need to create o/p port again.
I think we can't remove duplicates only by using filter
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explain in detail scd type 2 through mapping.
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Explain sql transformation in script mode examples in informatica
can u give example for factless fact table
What is the surrogate key?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How do we call shell scripts from informatica?
What is option by which we can run all the sessions in a batch simultaneously?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Define enterprise data warehousing?
Differentiate between sessions and batches?
What is transformation?
How to elaborate tracing level?
Enlist the differences between database and data warehouse.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?