5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
10
Answers were Sorted based on User's Feedback
Answer / rambabubollineni
while that time we use transformer stage
in transformer stage we use function like mod(source
colname,3)=1 for first target.for2nd target we write
mod(s.col,3)=2,for3rd target mod(s.col,3)=0. fimally we get
results.
Is This Answer Correct ? | 12 Yes | 1 No |
what are the errors,warnings in datastage
how to handle null values using transformer stage?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
How you can fix the truncated data error in datastage?
detail about sdlc
How the ipc stage work?
whats relation between configuration file and datasets?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?
how many rows sorted in sort stage by default in server jobs
Highlight the main features of datastage?
What are the unit test cases you used in your project?