How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
Answer Posted / krithi
When you use 'Select Distinct' option , the Sorter
Transformation discards the duplicate records.
If you want to trace out the duplicate records, then send
the sorted data into Expression Transformation. Add a new
variable and compare the variable with the input data. If
the data matches then flag the record or else pass the
default row.And load all the flagged records into a
seperate table.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How are indexes created after completing the load process?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is the fact table?
Explain sessions and how many types of sessions are there?
What is domain and gateway node?
How can we use batches?
How do you migrate data from one environment to another?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
how we can load rejected record's at run time?(not through bad files)
How to go to the older version for a mapping?
How do we call shell scripts from informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Describe expression transformation?
What is the need for an etl tool?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.