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 / sindhu

BY using sequential file in format delimeter =none while importing the data enable the option fixed width and give column width 5 space 5 space 5.datatype as varchar inorder to get zeros also in output.
reducing the stages will always increase performance

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to sort two columns in single job in datastage.

2845


I have a few records just I want to store data in to targets cycling way how?

2305


Highlight the main features of datastage?

1091


Why do we use exception activity in Datastage?

1231


What is difference between server jobs & parallel jobs?

989


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4141


How to convert RGB Value to Hexadecimal values in datastage?

3931


what is the use of materialized view?

1489


What is a merge?

1078


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

1687


What are the different type of jobs in datastage?

1002


Differentiate between odbc and drs stage?

1000


How to manage date conversion in Datastage?

1072


What is the use of hoursfromtime() function in transformer stage in datastage?

1003


what is ds administrator used for?

1118