Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 13 Answers
- 20635 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
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
What is difference between symmetric multiprocessing and massive parallel processing?
Terminate Activity
What is the difference between passive stage and active stage?
what is 'reconsideration error' and how can i respond to this error and how to debug this
What are the enhancements made in datastage 7.5 compare with 7.0?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Describe link sort?
What are the types of views in datastage director?
Give an idea of system variables.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How a routine is called in datastage job?
What is "fatal error/rdbms code 3996" error?
What are system variables and sequencers in datastage
How can we improve performance of data stage jobs?
Explain usage analysis in datastage?
