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
Describe the architecture of datastage?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
How to reverse the string using unix?
Could anyone give brief explanation bout datastage admin
Can we use target hash file as a lookup ?
Explain connectivity between datastage with datasources?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
root tree will find which is server job and which is parallel job?
Is possible to create skid in dim,fact tables?
which r the connectors used in san?
Name the third party tools that can be used in datastage?
What is a quality stage in datastage tool?
What are the important features of datastage?
How many areas for files does datastage have?
how to sort two columns in single job in datastage.