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 steps should be taken to improve Datastage jobs?
What is "fatal error/rdbms code 3996" error?
What are data elements?
Which commands are used to import and export the datastage jobs?
Define Job control?
What is the purpose of pivot stage?
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 to perform incremental load in datastage?
Can you explain engine tier in information server?
Difference between server jobs & parallel jobs?
What are some prerequisites for datastage?
What all the types of jobs you developed?
What is datastage?
Describe the architecture of datastage?
sed,awk,head