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
- 8636 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
Define repository tables in datastage?
Can you explain repository tables in datastage?
What is a merge in datastage?
How to read multiple files using a single datastage job if files have the same metadata?
What is the importance of the exception activity in datastage?
Have you used Unstructured data?
Which algorithm you used for your hashfile?
How a routine is called in datastage job?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How do you register plug-ins?
How can you write parallel routines in datastage PX?
Name the third party tools that can be used in datastage?
What is orabulk stage?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is the differentiate between data file and descriptor file?
