Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records in a flat file source?
- 2 Answers
- 8665 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / bsgsr
conncet the flat file to sorter transformation and select
distinct option.
| Is This Answer Correct ? | 17 Yes | 6 No |
Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.
| Is This Answer Correct ? | 0 Yes | 0 No |
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
r u done any partitions in ur project?
Briefly define reusable transformation?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?
what is surrogate id ?
In Real Time what are the scenarios u faced, what r the tough situations u have overcome, and explain about sessions.
2 Answers Cap Gemini, CTS, TCS, Tech Mahindra, Wipro,
What is data movement mode in Informatica and difference between them?
Have you worked with/created Parameter file
What is a repository manager?
What is rank transform?
Why do we use DSS database for OLAP tools?
Teradata 
