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
- 18579 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
Define repository tables in datastage?
What are the functionalities of link partitioner and link collector?
Explain ibm infosphere information server and highlight its main features?
Explain how a source file is populated?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the use of hoursfromtime() function in transformer stage in datastage?
Can you explain kafka connector?
sed,awk,head
Define Merge?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is meta stage?
How do you reject records in a transformer?
whom do you report?
how to sort two columns in single job in datastage.
What is active and passive stage?
