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
- 8752 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 are the types of containers?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
How a routine is called in datastage job?
What are the types of hashed files in data stage
What are the primary usages of datastage tool?
What are the different options associated with dsjob command?
Describe routines in datastage? Enlist various types of routines.
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
Triggers,VIEW,Procedures
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
sed,awk,head
What is the difference between orabulk and bcp stages?
What is datastage engine?
Notification Activity
