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
- 18581 Views
- Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / siva
SEQUENTIAL FILE.....>TRANSFORM.....>DATASET
IN TRANSFORM STAGE WE USE FIELD FUNCTION (OR)LEFT FUNCTION.
IN TRANSFORM >>>FUNCTIONS>>>STRINGS>>>FIELD(%string%,'%
delimter%',%occuarence%).
FIELD(subedar khaja.,' ',1)=column1.
FIELD(subedar khaja.,' ',2)=column2
| Is This Answer Correct ? | 18 Yes | 2 No |
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 |
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
How to clean the datastage repository?
how to sort two columns in single job in datastage.
What is the difference between odbc and drs stage?
Explain usage analysis in datastage?
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers
How to reverse the string using SQL?
What is the process of killing a job in datastage?
i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
source 1123445 I WANT OUTPUT AS DUPLICATES TO TARGET1 LIKE TARGET1 1144 NON-DUPLICATES TO TARGET2 TARGET2 235
Teradata 
