Hi This is Vijay,
How can your remove the duplicates in sequential File?
Answer Posted / charan
hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
What is merge stage?
which r the connectors used in san?
How can we improve the performance in datastage?
Could anyone give brief explanation bout datastage admin
What is the difference between operational data stage (ods) and data warehouse?
Name the third party tools that can be used in datastage?
What are the processing stages?
What are the types of jobs we have in datastage?
What is usage analysis in datastage?
what is the difference between == and eq in UNIX shell scripting?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
State the difference between an operational datastage and a data warehouse?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are transforms and what is the differenece between routines and transforms?