i have source as Column1 101 a 101 b 101 c so i want to load target as colum

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

Question Posted / santhosh

3 Answers
5939 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

SQ - Exp - Target

In exp transformation

newport1 - SUBSTR(column1,1,3)
newport2 - LTRIM(RTRIM(column1))
newport3 - REPLACECHR(1,newport2,'101','')
newport4 - newport1 || ' ' || newport3

pass newport4 to target

anyone pls confirm if it is wrong

Is This Answer Correct ?

4 Yes

0 No

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

Answer / 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

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

Answer / mahesh

using Aggregator ......

create group by on col1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four

3 Answers

What is tracing level and what are the types of tracing level?

2 Answers TCS,

I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....

4 Answers Patni,

What is facttable granularity?

2 Answers

what is service oriented architecture in Informatica 8 version

1 Answers Cap Gemini, IBM, Systech, TCS,

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

0 Answers IBM,

What is difference between partioning of relatonal target and partitioning of file targets?

2 Answers

Where can we find the throughput option in informatica?

0 Answers

Diff b/w ShortCut and reusabel Object ?

4 Answers

What are the limitations of joiner transformation?

0 Answers Informatica,

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers Accenture,

Can we run session without using workflows?

5 Answers TCS,

For more Informatica Interview Questions Click Here