one file contains
col1
100
200
300
400
500
100
300
600
300
from this i want to retrive the only duplicate like this
tr1
100
100
300
300
300 how it's possible in datastage?can any one plz explain
clearley..........?
Answer Posted / chandu
use aggregator and calculate count of source column after
that use filter or transaformer stage use condition as count
>1 it gives only duplicate records
Thanks
Chandu-9538627859
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is difference between join, merge and lookup stage?
What is the differentiate between data file and descriptor file?
project Steps,hits, Project level HArd things,Solved methods?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
Explain datastage architecture?
What is a quality stage in datastage tool?
what is 'reconsideration error' and how can i respond to this error and how to debug this
Why do we use exception activity in Datastage?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Have you have ever worked in unix environment and why it is useful in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is job control?