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
- 20636 Views
- Bank Of America, IBM, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
Appreciate your Answer but it was wrong..because if you are using Agregator stage it will give only unique records with record count. so how can u print all the duplicate records.
in the above senario:
input to agregator stage: 251,251,456,456,951,985
i used count rows.
so, the o/p is 251,2
456,2
951,1
985,1
if U use the Filter stage then what is the output:
O/P1:
251
456
O/P2:
951
985
Unfortunately this is not the answer we are required...
This is not as simple as U think...i implemented it before posting!!!!!
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
Which warehouse using in your datawarehouse
What are stage variables?
How to read the length of word in unix?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Can you explain repository tables in datastage?
Why do you need stage variables?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Lookup constraints
What are the partitioning techniques available in link partitioner?
What are the different type of jobs in datastage?
options available in sequence job to run,validate?
What all are the different way to run a job?
What is the difference between an operational datastage and a data warehouse?
Explain the situation where you have applied SCD in your project?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
