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...

Hi this madan, in data stage one file in Empno 12345678910 in a table, i want target is 
Empno
1                               
2
3
4
5
6
7
8
9
10                             

                               
                               

Answer Posted / david

by using right and left function with loop function we can achieve this one

Is This Answer Correct ?    1 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between the local container and shared container?

1103


What steps should be taken to improve Datastage jobs?

1073


What is a merge?

1169


Differentiate between datastage and datastage tx?

1051


i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3759


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008


how to implement scd2 in datastage 7.5 with lookup stage

5605


Which algorithm you used for your hashfile?

1182


What are the difference types of stages?

1216


What is ds designer?

1105


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3460


Can you define merge?

1123


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224


Enlist various types of routines in datastage.

1257


What are the partitioning techniques available in link partitioner?

2279