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 / sudheer
- aggregator -
seq. file - copy join - filter - seq.op
in arrg - cnt rows
in join - left outer join - left as seq.file data
in filter - where cond. - cnt>1
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what is 'reconsideration error' and how can i respond to this error and how to debug this
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Name the third party tools that can be used in datastage?
Nls stands for what in datastage?
What are the components of datastage?
What are the different layers in the information server architecture?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the difference between odbc and drs stage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What is the difference between operational data stage (ods) and data warehouse?
What is the difference between informatica and datastage?
I have a few records just I want to store data in to targets cycling way how?
In Datastage, how you can fix the truncated data error?
What are the various kinds of containers available in datastage?
How to manage date conversion in Datastage?