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

in one scenario source flat file like
Fileld1
00122001550056200568
00256002360014500896
00123004560078900258
00147004560025800256
divide each 5 numbers as one column i.e
here i need
field1 field2 field3 field4
00122 00155 00562 00568
00256 00236 00145 00896
00123 00456 00789 00258
00147 00456 00258 00256
plz help me....

Answer Posted / anat

Hi as per my knowledge pls follow the below steps
1)take entire source as single colom
2)in transfomer split that colom in to multiple coloms by
using substring or field functons

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between validated and compiled in the datastage?

1376


explain about citrix scheduling tool in datastage

2512


What is quality stage?

1046


how to run a sequential file stage in parallel if the stage is used on the TARGET side

1795


what is ds administrator used for?

1222


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

3524


How to implement complex jobs in data stage?

1162


Differentiate between Join, Merge and Lookup stage?

1143


How do u convert the columns to rows in datastage?

1248


To see hidden files in LINIX?

1590


Differentiate between operational datastage (ods) and data warehouse?

1234


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2548


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1432


How you can fix the truncated data error in datastage?

1887


What are the differences between datastage and informatica?

1229