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
- 8627 Views
- I also Faced
- E-Mail Answers
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 is a merge?
What are the different layers in the information server architecture?
Differentiate between hash file and sequential file?
How to manage date conversion in Datastage?
Explain the importance of surrogate key in data warehousing?
Is possible to create skid in dim,fact tables?
What are stage variables?
How to perform incremental load in datastage?
options available in sequence job to run,validate?
table actions available in oracle connector?
Name the command line functions to import and export the DS jobs?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between validated and compiled in the datastage?
What are the main features of datastage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
