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
- 18468 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 RD using transformer?
Explain datastage architecture?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Why do we use link partitioner and link collector in datastage?
Define APT_CONFIG in Datastage?
explain about citrix scheduling tool in datastage
Can you explain engine tier in information server?
how can we create rank using datastage?what is the meaning of rank?
how to abort the job its matain duplicates?
How a source file is populated?
What is the difference between orabulk and bcp stages?
What is the difference between an operational datastage and a data warehouse?
What are the different common services in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How to reverse the string using SQL?
