Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / venugopal
Hi Vijay it's simple
In the source sequential file goto Output->Properties
under options you mention reject mode = Output.
This will gives the duplicate records in the output.
This will 100% work why because in my present project we
are using the same format.
| Is This Answer Correct ? | 3 Yes | 10 No |
Post New Answer View All Answers
Explain entity, attribute and relationship in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
What are the types of containers and how to create them?
What are the difference types of stages?
What is a folder? Difference types of stages?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What is the method of removing duplicates, without the remove duplicate stage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
how to export or import the jobs in .ISX file
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the different layers in the information server architecture?
What is quality stage?
project Steps,hits, Project level HArd things,Solved methods?
If you want to use the same piece of code in different jobs, how will you achieve it?
how to implement scd2 in datastage 7.5 with lookup stage