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
- 20114 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
Describe stream connector?
How can you write parallel routines in datastage PX?
How many areas for files does datastage have?
Can you explain kafka connector?
Can we use target hash file as a lookup ?
what is flow of project?
Define Routines and their types?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
What is the process of killing a job in datastage?
What are the components of ascential data stage?
how can we create rank using datastage?what is the meaning of rank?
Explain datastage architecture?
What are the steps required to kill the job in Datastage?
Nls stands for what in datastage?
