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
- 8641 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 process model?
which r the connectors used in san?
Why do we use exception activity in Datastage?
What are transforms and what is the differenece between routines and transforms?
How many types of views are there in a datastage director?
What are the functionalities of link partitioner?
What are the steps required to kill the job in Datastage?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What are datastage sequences?
Enlist various types of routines in datastage.
What are the features of datastage flow designer?
What is the difference between datastage and informatica?
What is a merge in datastage?
How you can fix the truncated data error in datastage?
EXPLAIN SCD
