Interested to Buy Any Domain ? << Click Here >> for more details...
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 21463 Views
- iNautix, I also Faced
- E-Mail Answers
Answer Posted / joe
Option 1: using Unix for flat files
Option2: Using Checksum function in the expression to
generate a unique hexadecimal code for each record.
and comparing the same with the next record.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is aggregator transformation in informatica?
What is a joiner transformation?
Enlist few areas or real-time situations where informatica is required.
Explain the aggregator transformation?
how many types of dimensions are available in informatica?
Explain the code page compatibility?
What is a difference between complete, stop and abort?
How do you migrate data from one environment to another?
Briefly define reusable transformation?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the command used to run a batch?
What are the types of lookup transformation?
