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

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

0 Answers   IBM,

What is datastage engine?

0 Answers  

how to capture rejected data by using join stage not for lookup stage. please let me know

3 Answers   Satyam,

What is the use of surrogate key stage?

2 Answers  

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

0 Answers  

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

Pls tell me what is troubleshooting in datastage view?

1 Answers  

What are the partition techniques available in your last project?

1 Answers  

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories