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
- 8628 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
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
What is staging variable?
What are routines in datastage? Enlist various types of routines.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are some different alternative commands associated with "dsjob"?
options available in sequence job to run,validate?
Does datastage support slowly changing dimensions ?
What is merge stage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Where the datastage stored his repository?
Define repository tables in datastage?
Nls stands for what in datastage?
Terminate Activity
Can you explain engine tier in information server?
Enlist various types of routines in datastage.
