how can we generate row values like
1
1
1
2
2
2
3
3
3
using col generator
plz let me know
Answer Posted / peeyush sehgal
Take input file like 0 1 2 3 4 5 6 7 8 9
seq -> trans -> seq
in transformer, clear its partitioning and sort the data.
then in stage variable
initialize sv=1
if inputlink%3=0 then sv+1 else sv
populate sv in output column.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
Name the command line functions to import and export the DS jobs?
What is the difference between an operational datastage and a data warehouse?
What are routines in datastage? Enlist various types of routines.
How to reverse the string using SQL?
What is the difference between datastage and datastage tx?
In Datastage, how you can fix the truncated data error?
what are the devoleper roles in real time? plz tell i am new to datastage....
project Steps,hits, Project level HArd things,Solved methods?
What is the difference between server job and parallel jobs?
What is a datastage job?
Define Data Stage?
What is quality stage?
How you can fix the truncated data error in datastage?
What are iconv and oconv?