How to convert multiple rows into single row in datastage
Can you please solve this in datastage..
my input is
want output as
pls explain with steps
thanking in advance...
Display the Rank in asending & descending order for salary column
Can anybody solve this interview question in DataStage?
My input is:
EMPNO, DEPTNO, SALARY
1 A 100
2 A 4000
3 A 400
4 B 500
5 B 150
6 B 700
I need extra column "Rank" in the output is:
EMPNO, DEPTNO, SALARY,...
Convert multiple rows into single row
i have sourse like
want output like.....
thanks in advance...
Output using stage variable concept of transformer only (remove reserve duplicates)
SOURCE DESTINATION DISTANCE(KM)
HYD CHN 500
CHN HYD 500
BANG HYD 600
HYD BANG 600
PUN HYD 750
HYD PUN 750
How to remove reverse duplicates in datastage ?
Objective: The interface aims to consolidate the round-trip ticket cost of passengers.
Description: The source file is a .txt file, train_route_src.txt, consolidated with trains from a particular source to destination. There are many repetitions in the source file (Reverse Duplication: eg. BLR --> BBS and BBS --> BLR). Remove the reverse duplicates and maintain the target in...
DataStage - delete header and footer on the source sequential
How do you you delete header and footer on the source sequential file and how do you create header and footer on target sequential file using datastage?
Datastage Job Scenario question
input file A contains12345678910input file B contains6789101112131415Output file X contains12345Output file y contains678910Output file z contains1112131415How can we do in this in a single ds job in px ?....could you please give me the logic to implement ???
Datastage job scenario question
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
Datastage Real time scenario
In source table data like this
but I want traget table like this
pls any one one solve this........
I would like to have output as like this 101 90 next line 102 65 next line 102 55 etc...
11. Find The Output With out PIVOTE stage
Source File: Target
SNO, MATHS, PHYSICS, CHEMISTRY SNO, MARKS
101, 70, 80, 90 101, 70
102, 65, 55, 75 101, 80
Dataset stage and sequential file stage
what is the difference between dataset stage and sequential file stage? even one more to be added here, What is the difference between dataset stage and fileset stage?
DataStage Interview Questions