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 / me
seq----> copy
from copy stage one link to aggregator apply count rows option ---> filter (on count rows output 1 ) send as reference to look up below
from copy stage second link to lookup
apply filter
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you explain players in datastage?
how to write server Routine coding?
what are the errors,warnings in datastage
How many types of views are there in a datastage director?
What are orabulk and bcp stages?
What are the different types of lookups in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is oci?
In Datastage, how you can fix the truncated data error?
Explain the situation where you have applied SCD in your project?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are stage variables and constants?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Define Routines and their types?