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
- 17873 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
how to abort the job its matain duplicates?
What is the differentiate between data file and descriptor file?
What are orabulk and bcp stages?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
What are the main differences you have observed between 7.x and 8.x version of datastage?
Where the datastage stored his repository?
Differentiate between datastage and datastage tx?
How do you import and export data into datastage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
Which algorithm you used for your hashfile?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Describe link sort?
What is apt_config in datastage?
Can you explain players in datastage?
what are the errors,warnings in datastage
