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
- 18452 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
What is oci?
What are the repository tables in datastage?
What are the different types of lookups in datastage?
What are the types of hashed files in data stage
What are the areas of application?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Where the datastage stored his repository?
what is the custome stage in datastage? how can we impliment that one? plz tell me
What are the steps needed to create a simple basic datastage job?
what are the errors,warnings in datastage
What are constraints and derivations?
Define Merge?
What are sequencers?
What are the different common services in datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
