I have a scenario like
Deptno=10---->First record and last record
Deptno=20---->First record and last record
Deptno=30---->First record and last record
I want those first and last records from each department in
a single target. How to do this in DataStage, any one can
assist me.
Thanks in advance.
Answer Posted / naga
take sequential file and give its output to copy and copy
it to two datasets.in one dataset select the partition on
deptno type=modulus and perform sort and select both stable
and unique you will get first redcords and in another
dataset select partition on deptno and type modulus and
perform sort and select only unique and give give both
dataset outputs to funnel and give its output to dataset
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
how to export or import the jobs in .ISX file
Triggers,VIEW,Procedures
What is the command line function to import and export the ds jobs?
What is the different type of jobs in datastage?
describe the Steps to confiure a Qlogic switch
How one source columns or rows to be loaded in to two different tables?
project Steps,hits, Project level HArd things,Solved methods?
What is difference between symmetric multiprocessing and massive parallel processing?
Explain ibm infosphere information server and highlight its main features?
What are orabulk and bcp stages?
How and where you used hash file?
What are system variables and sequencers in datastage
What are the types of containers in datastage?
How many types of sorting methods are available in datastage?
What is use Array size in datastage