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?
Answer Posted / 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 |
Post New Answer View All Answers
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Why we use surrogate key?
explain about citrix scheduling tool in datastage
Notification Activity
options available in sequence job to run,validate?
Difference between server jobs & parallel jobs?
root tree will find which is server job and which is parallel job?
EXPLAIN SCD
Have you have ever worked in unix environment and why it is useful in datastage?
Can you explain repository tables in datastage?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
what is 'reconsideration error' and how can i respond to this error and how to debug this
Can you define merge?
Define Routines and their types?
Distinguish between informatica & datastage. Which one would you choose and why?