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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

In Sequential file, how can i split a column into two, and
that column contains string datatype.
For Example, i have column of string datatype as subedar
khaja. Now i want get output as separately with subedar in
one column and khaja in second column.
How?
Coula anybody, solve it?

Question Posted / subedar.khaja

Answers were Sorted based on User's Feedback



In Sequential file, how can i split a column into two, and that column contains string datatype. ..

Answer / siva

SEQUENTIAL FILE.....>TRANSFORM.....>DATASET
IN TRANSFORM STAGE WE USE FIELD FUNCTION (OR)LEFT FUNCTION.
IN TRANSFORM >>>FUNCTIONS>>>STRINGS>>>FIELD(%string%,'%
delimter%',%occuarence%).
FIELD(subedar khaja.,' ',1)=column1.
FIELD(subedar khaja.,' ',2)=column2

Is This Answer Correct ?    18 Yes 2 No

In Sequential file, how can i split a column into two, and that column contains string datatype. ..

Answer / vinod upputuri

That's is right siva. Here is another set of solution:

i/p is ColA which contains Vinod Upputuri.
in order to spit this column into two columns, I am going
to use Column Import stage.

SEQSTAGE>>>COLUMNIMPORT>>>TARGET.

In column import stage>>> we have to specify the import key
column, then specify the column to export: in this case
First_name,Last_Name etc.

Note: Specify the Delimeter as per the input format.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Data Stage Interview Questions

What is a folder? Difference types of stages?

0 Answers  

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

What is the project in datastage?

0 Answers  

Triggers,VIEW,Procedures

0 Answers   CTS,

How to add zero "0" before record in a field?

4 Answers  

What is orabulk stage?

0 Answers  

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

How do you load dimension data and fact data? Which is first

2 Answers  

Hi This is Vijay, How can your remove the duplicates in sequential File?

15 Answers   HCL, Scope International,

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

0 Answers   Wipro,

What is "fatal error/rdbms code 3996" error?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories