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
- 17144 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
How many Key we can define in remove duplicate stage?
How to manage date conversion in Datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is a quality stage in datastage tool?
What are the partitioning techniques available in link partitioner?
Can we use target hash file as a lookup ?
What are the different plug-ins stages used in your projects?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What is the purpose of interprocessor stage in server jobs?
Can you define merge?
What all the types of jobs you developed?
What are the different common services in datastage?
What is the difference between an operational datastage and a data warehouse?
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
