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
- 18498 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 merge stage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many types of hash files are there?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
Explain the importance of surrogate key in data warehousing?
Name the command line functions to import and export the DS jobs?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
In Datastage, how you can fix the truncated data error?
How do you generate sequence number in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Explain usage analysis in datastage?
What is difference between server jobs & parallel jobs?
How you Implemented SCD Type 1 & Type 2 in your project?
How many types of sorting methods are available in datastage?
what is the use of materialized view?
