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
How do you import and export the datastage jobs?
What is aggtorec restructure operator?
Differentiate between validated and Compiled in the Datastage?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What is merge stage?
How we can covert server job to a parallel job?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the command line function to import and export the ds jobs?
On which interface you will be working as a developer?
What is difference between symmetric multiprocessing and massive parallel processing?
EXPLAIN SCD
If you want to use a same piece of code in different jobs, how will you achieve this?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
How to find value from a column in a dataset?
Notification Activity