Interested to Buy Any Domain ? << Click Here >> for more details...
how can we generate row values like
1
1
1
2
2
2
3
3
3
using col generator
plz let me know
- 2 Answers
- 8751 Views
- I also Faced
- E-Mail Answers
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
Have you used Unstructured data?
What is the different type of jobs in datastage?
What is the differentiate between data file and descriptor file?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Explain connectivity between datastage with datasources?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
How one source columns or rows to be loaded in to two different tables?
Explain how a source file is populated?
Can you define merge?
How to read the length of word in unix?
How to implement complex jobs in data stage?
What is the difference between datastage and informatica?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
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....
