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 a datastage macro?

0 Answers  

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

How many partitions does a node can have? Some body explain me clearly about the partitions and the nodes?

3 Answers  

Can you highlight the main features of ibm infosphere information server?

0 Answers  

How a server job can be converted to a parallel job?

0 Answers  

How can you join flat file, oracle as a sources?

4 Answers   IBM,

what are the types of nodes

4 Answers   HCL, TCS,

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

0 Answers  

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

Name the different types of Lookups in Datastage?

0 Answers  

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories