using SQL SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(T

i have source as
Column1
101 a 101 b 101 c
so i want to load target as
column1 ---> 101 abc

Question Posted / dilip ingole

Answer Posted / dilip ingole

using SQL

SELECT SUBSTR('101 a 101 b 101 c',1,4) ID ,REPLACE(TRANSLATE('101 a 101 b 101 c','1234567890',' '),' ','') DATA FROM DUAL;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is incremental aggregation?

1081

Explain sessions. Explain how batches are used to combine executions?

1031

Explain constraint based loading in informatica

1093

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2305

What is data caches/ index caches?

1100

Explain joiner transformation in informatica

1124

What do you mean by channel change?

1041

What are the types of schemas we have in data warehouse.

957

what is mean by complex business rule ?

2158

What are the differences between source qualifier and joiner transformation?

1060

Is it possible to revert a global repository to local one and why?

1080

What is an expression transformation in informatica?

1036

Can we change Dynamic to Static or Persistent cache? If so what happens?

2209

How to generate sequence numbers without using the sequence generator transformation?

1205

How to create a non-reusable instance of reusable transformations?

1131