Interested to Buy Any Domain ? << Click Here >> for more details...
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..........?
- 8 Answers
- 13500 Views
- IBM, I also Faced
- E-Mail Answers
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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is datastage engine?
What is merge stage?
What are the important features of 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)
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
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 are the components of ascential data stage?
What is the purpose of interprocessor stage in server jobs?
What is quality stage?
How and where you used hash file?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
