i want send my all duplicate record one tar and all uniq
records one target how we will perfome explain
example:
input data
eid
251
251
456
456
951
985
out put/target1
251
251
456
456
out put/target2
951
985
how we will bring
Answer Posted / vsandu
just sort the data ,and bring key changevalues by using
sort ,
in transformer write a logic if group id is 1,0 then target
1 else if group id is anly 1 then target2
as per my knowledge ,if any mistake correct me
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How do you generate sequence number in datastage?
what is the difference between == and eq in UNIX shell scripting?
What are the various kinds of the hash file?
How can we improve performance of data stage jobs?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Define Routines and their types?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Name the different sorting methods in datastage.
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
How do you reject records in a transformer?
Define Merge?
What is the purpose of pivot stage?
What is "fatal error/rdbms code 3996" error?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What are the different options associated with dsjob command?