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?

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

Can you explain kafka connector?

0 Answers  


How many types of stage?

0 Answers  


HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  


I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  


What is the difference between Datastage 7.5 and 7.0?

0 Answers  






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

7 Answers   IBM,


Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,


what are the devoleper roles in real time? plz tell i am new to datastage....

0 Answers   Mphasis,


Define ds designer?

0 Answers  


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

0 Answers  


What are the functionalities of link collector?

0 Answers  


Lookup constraints

0 Answers   CTS,


Categories