Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete duplicate records by using filter
transfermation?
- 3 Answers
- 7946 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
by using only filter t/r we cannot delete duplicate records.
but by using combination of aggrigator and filter t/r we can achive it
in aggrigator t/r create a new o/p port to count_rec with expression count(key column)
connect all the ports to filter and write a condition count_rec=1.now connect ports to the target
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / mahaboob basha
connot delete the duplicate records while using filter t/r
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
How to get rid of non ascii characters in a string? Ex:- United States Microsoft Visual Studio Tools for Applications 2012 x86 主控支援 - 繁體中文語言套件 to United States Microsoft Visual Studio Tools for Applications 2012 x86.
What are the connected or unconnected transforamations?
How does a rank transform differ from aggregator transform functions max and min?
What are the mapping paramaters and mapping variables?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
How do you load unique records into one target table and duplicate records into a different target table?
What are the new features of informatica 7.1?
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
Can we change Dynamic to Static or Persistent cache? If so what happens?
what is the logic will you implement to load data into a fact table from n dimension tables?
Teradata 
