Hi am sundar, i have datas like
00023-1010
00086-1010
00184F2-1010
.
.
.
.
SCH-AS-1010
200-0196-039
.
.
.
Now i want the result as values before the delimiter should
come under the column ITEM_CODE and values after the
delimiter should come under the column LOC_CODE.. But some
datas like "SCH-AS-1010", for this, "SCHAS" should come
under the column ITEM_CODE and 1010 should come under the
column LOC_CODE.. Pls help me..
- 1 Answers
- 5349 Views
- I also Faced
- E-Mail Answers
Answer / kiran
hi this is kiran..,
u can do manipulate in transformer stage.in tranformer
stage some functions is ther like
FIELD('sring',delimeter,occurence.....) like that
A=Field('SCH-AS-1010','-',1)
B=Field('SCH-AS-1010','-',2)
C=Field('SCH-AS-1010','-',3)
then
concatenate A and B in ITEM_CODE C in LOC_CODE.
| Is This Answer Correct ? | 7 Yes | 1 No |
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
whats relation between configuration file and datasets?
Can we use target hash file as a lookup ?
detail about sdlc
EXPLAIN SCD
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
What is the difference between lookup and sparse lookup?
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
How do you load dimension data and fact data? Which is first
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
How complex jobs are implemented in datstage to improve performance?
Teradata 
