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
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...
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 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 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...
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...
Convert multiple rows into columns in datastage
i have sourse like
want output like
thanks in advance..
Datastage Real time scenario
In source table data like this
but I want traget table like this
pls any one one solve this........
Convert multiple rows into single row
i have sourse like
want output like.....
thanks in advance...
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
Datastage scenario - Flat file
Source is a flat file and has 200 records . These have to split across 4 outputs equally . 50 records in each .
The total number of records in the source may vary everyday ,according to the count records are to split equally at 4 outputs.
Could someone post an answer for this question.
DataStage Interview Questions