Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 8 Answers
- 21859 Views
- I also Faced
- E-Mail Answers
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
what is ds administrator used for?
What are sequencers?
How do you remove duplicate values in datastage?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
Define orabulk and bcp stages?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
State the difference between an operational datastage and a data warehouse?
How one source columns or rows to be loaded in to two different tables?
What is the roundrobin collector?
How will you move hashed file from one location to another location?
Differentiate between operational datastage (ods) and data warehouse?
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
how to implement scd2 in datastage 7.5 with lookup stage
Why do we use link partitioner and link collector in datastage?
What is meta stage?
