Interested to Buy Any Domain ? << Click Here >> for more details...
Hi This is Vijay,
How can your remove the duplicates in sequential File?
- 15 Answers
- 30940 Views
- HCL, Scope International, I also Faced
- E-Mail Answers
Answer Posted / arun
Sort the incoming data using a sort stage & use remove
duplicates on the key columns. This will remove the
duplicates in ur source file.
| Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the difference between validated and compiled in the datastage?
Differentiate between datastage and informatica?
What are the different types of lookups in datastage?
What are the main differences you have observed between 7.x and 8.x version of datastage?
how to export or import the jobs in .ISX file
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
Differentiate between validated and Compiled in the Datastage?
Give an idea of system variables.
whom do you report?
What are the types of containers and how to create them?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
