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
- 17178 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
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
What is aggtorec restructure operator?
What are the types of containers in datastage?
What are data elements?
What is the use of datastage director?
Explain the situation where you have applied SCD in your project?
in oracle target stage when we use load option and when we use upsert option?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Have you have ever worked in unix environment and why it is useful in datastage?
What are routines in datastage? Enlist various types of routines.
Difference between server jobs & parallel jobs?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between validated and compiled in the datastage?
What are the functionalities of link partitioner and link collector?
What is process model?
