Interested to Buy Any Domain ? << Click Here >> for more details...
How can i catch the Duplicate Rows From SorterTrans in a
Seperate Target Table ?
- 2 Answers
- 8313 Views
- I also Faced
- E-Mail Answers
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
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How can you define user defied event?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Could you explain what is enterprise data warehouse?
What is the command used to run a batch?
What is depict expression change?
Explain joiner transformation in informatica
Enlist few areas or real-time situations where informatica is required.
Performance tuning in UNIX for informatica mappings?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the sequence generator transformation in informatica?
Is it possible to use a client with different version than that of its Informatica server?
Which transformation should we use to normalise the COBOL and relational sources?
Different circumstance which drives informatica server to expel records?
