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 / peeyush sehgal

Take input file like 0 1 2 3 4 5 6 7 8 9
seq -> trans -> seq

in transformer, clear its partitioning and sort the data.
then in stage variable
initialize sv=1

if inputlink%3=0 then sv+1 else sv

populate sv in output column.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2472


Name the command line functions to import and export the DS jobs?

1169


What is the difference between an operational datastage and a data warehouse?

1162


What are routines in datastage? Enlist various types of routines.

1104


How to reverse the string using SQL?

1540


What is the difference between datastage and datastage tx?

1074


In Datastage, how you can fix the truncated data error?

1169


what are the devoleper roles in real time? plz tell i am new to datastage....

2167


project Steps,hits, Project level HArd things,Solved methods?

2142


What is the difference between server job and parallel jobs?

1166


What is a datastage job?

1023


Define Data Stage?

1102


What is quality stage?

996


How you can fix the truncated data error in datastage?

1803


What are iconv and oconv?

1252