Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 2 Answers
- 18694 Views
- Polaris, I also Faced
- E-Mail Answers
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
Can you define merge?
What is job control?
What are the some differences between 7.x and 8.x version of datastage?
Define meta stage?
What are the processing stages?
What are the stages in datastage?
What are the different layers in the information server architecture?
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the difference between datastage and datastage tx?
Nls stands for what in datastage?
What are the different plug-ins stages used in your projects?
What are the primary usages of datastage tool?
root tree will find which is server job and which is parallel job?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How a routine is called in datastage job?
