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
- 18587 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / vinod upputuri
That's is right siva. Here is another set of solution:
i/p is ColA which contains Vinod Upputuri.
in order to spit this column into two columns, I am going
to use Column Import stage.
SEQSTAGE>>>COLUMNIMPORT>>>TARGET.
In column import stage>>> we have to specify the import key
column, then specify the column to export: in this case
First_name,Last_Name etc.
Note: Specify the Delimeter as per the input format.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Define Routines and their types?
Why do you need stage variables?
What are the various kinds of the hash file?
Define data aggregation?
Explain ibm infosphere information server and highlight its main features?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are the steps required to kill the job in Datastage?
Why do we use link partitioner and link collector in datastage?
Explain the importance of surrogate key in data warehousing?
Define repository tables in datastage?
What a datastage macro?
What are the job parameters?
Can we use target hash file as a lookup ?
How to manage date conversion in Datastage?
how to write server Routine coding?
