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
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 |
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 |
Can you explain kafka connector?
How many types of stage?
HOW CAN WE SEE THE DATA IN DATASET?
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
What is the difference between Datastage 7.5 and 7.0?
how can u find out the datastage job is running on how many nodes
Hai..,in datastage how to explain project in interview?please explain any domain please.
what are the devoleper roles in real time? plz tell i am new to datastage....
Define ds designer?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the functionalities of link collector?
Lookup constraints