Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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


Please Help Members By Posting Answers For Below Questions

What are the some differences between 7.x and 8.x version of datastage?

1204


What is oci?

1259


whom do you report?

1879


client know skid info?

2034


What are the stages in datastage?

1026


What are the functionalities of link collector?

1032


Where the datastage stored his repository?

1018


Explain ibm infosphere information server and highlight its main features?

1033


Differentiate between datastage and informatica?

1139


EXPLAIN SCD

1336


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2324


What is size of a transaction and an array means in a datastage?

1234


What are the areas of application?

1089


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2404


What is ibm datastage flow designer?

1078