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

How do you start developing a datastage project?

1089


What is the sortmerge collector?

1118


How do y read Sequential file from job control?

15920


Explain usage analysis in datastage?

1147


How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?

2602


What are sequencers?

1093


Can you filter data in hashed file?

3760


Explain how a source file is populated?

1351


What are the processing stages?

1085


What is the process of killing a job in datastage?

999


What is the difference between Datastage 7.5 and 7.0?

1085


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2172


What is datastage engine?

1166


What are the different layers in the information server architecture?

1116


What is the difference between passive stage and active stage?

1507