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 / siva
src-->copy-->agg
| |
| |
join stage--filter--uniq
|
|
dup
this is senario ans
plz do this u get correct answer
thanks
siva
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain the datastage parallel extender (px) or enterprise edition (ee)?
What is the use of datastage director?
Can you explain link buffering?
Describe link sort?
What are system variables and sequencers in datastage
What are the different common services in datastage?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
What can we do with datastage director?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What are the types of jobs we have in datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
Is possible to create skid in dim,fact tables?
what is repositery?