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 / koti
seq -----------cg------------seq
Take input file like
1
2
3
4
5
6
7
8
9
10
comming to CG
Column Method =Explicit
column Generate = Test
go to cg Porperties output ----Mapping----- map the test column----ok
next ,column---edit column meta data--columnname test--sqltype integer----parallel properties---genartor-
type=cycle,increment =1,intial vlue=1.
go to target file do link sort to outputfile
go to apt_config file
check how many node is their
if it 2 nodes
you just create one more node that means total 3nodes.
while runing a job run on 3 nodes.
you will get output like
1
1
1
2
2
2
3
3
3
4
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the some differences between 7.x and 8.x version of datastage?
What is oci?
whom do you report?
client know skid info?
What are the stages in datastage?
What are the functionalities of link collector?
Where the datastage stored his repository?
Explain ibm infosphere information server and highlight its main features?
Differentiate between datastage and informatica?
EXPLAIN SCD
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is size of a transaction and an array means in a datastage?
What are the areas of application?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is ibm datastage flow designer?