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
- 17190 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
Name the third party tools that can be used in datastage?
How will you move hashed file from one location to another location?
What are the different common services in datastage?
How we can covert server job to a parallel job?
State the difference between an operational datastage and a data warehouse?
What are routines in datastage?
how to sort two columns in single job in datastage.
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the importance of the exception activity in datastage?
In Datastage, how you can fix the truncated data error?
Highlight the main features of datastage?
Can you explain engine tier in information server?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
