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
Why do we use link partitioner and link collector in datastage?
what is the use of skid in reporting?
CHANGE CAPTURE
Why do you need stage variables?
Distinguish between informatica & datastage. Which one would you choose and why?
what is the use of surogate key in datastage
What is oci?
How do y read Sequential file from job control?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How do you import and export the datastage jobs?
What are the types of views in datastage director?
Nls stands for what in datastage?
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
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between server job and parallel jobs?