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?
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 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 Technical Questions
1. Is the Hash file is active or passive? If we take as source ?2. can u take seq file as look up?3. In hash file dynamic 30, there r two types:1)genaric2)specific what is the meaning?4. how to connect MERGE STAGE while source as two tables?5. what is the purpose of MERGE?6. how can DS job scheduled in Unix?7. how do u know how many rows rejected?8. use of universe stage?9. what is SEQ file buffer?10. diff...
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...
Distribution of Number of rows equally.
I have 100 rows in a table and want to distribute the data by 4 equal parts and write to four sequential file. here the source data keeps changing. Example : if source data is having 1000 rows the target files have to get 250 rows each in the four files.
1000/4 = 250 each
100/4 =25 each
Convert multiple rows into columns in datastage
i have sourse like
want output like
thanks in advance..
Single column with multiple rows should be converted into single row with commas in datastage
Can any one help....
I have single column in Source like.....
want target as.....
thanks in advance
DataStage Interview Questions