Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?
- 11 Answers
- 21581 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / d.bharath
Take source and copy,aggregate,transformer and lookup,
1) give one copy output link to aggr,
2)In arggr perform count rows,
3)And in transformer check constrains count>1,count>2
4)And lookup the result of count>2 with the second output
link of copy stage.the you will get the all repeated rows
into on one output dataset.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
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
options available in sequence job to run,validate?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is use Array size in datastage
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the types of containers in datastage?
What a datastage macro?
Can we use target hash file as a lookup ?
What are some prerequisites for datastage?
What is usage analysis in datastage?
How can one find bugs in job sequence?
In Datastage, how you can fix the truncated data error?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is the purpose of interprocessor stage in server jobs?
