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
- 8521 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
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
How do you generate sequence number in datastage?
Notification Activity
what is ds administrator used for?
Define Merge?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
how can we create rank using datastage?what is the meaning of rank?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Distinguish between informatica & datastage. Which one would you choose and why?
How you can fix the truncated data error in datastage?
What are the components of datastage?
What are some prerequisites for datastage?
What is the use of datastage designer?
Differentiate between datastage and informatica?
Explain entity, attribute and relationship in datastage?
