In expr_trns we can use--- REPLACECHR ( 1, "111111111111ravi11111

111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?

Question Posted / murali

Answer Posted / murali

In expr_trns we can use---

REPLACECHR (
1, "111111111111ravi11111111kumar11111111111" , '1', NULL)

Thanks,
Murali Udayagiri

Is This Answer Correct ?

1 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How you know when to use a static cache and dynamic cache in lookup transformation?

1856

What can we do to improve the performance of informatica aggregator transformation?

1095

Is stop and abort are same in informatica?

1002

Under what condition selecting sorted input in aggregator may fail the session?

1127

What are the uses of etl tools?

1129

What is workflow monitor?

1063

what is index?how it can work in informatica

2043

What is persistent lookup cache?

1035

How to Create a folder using pmrep command?

1177

what is the Default Source Option For Update Strategy Transformation?

1242

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1786

What are active and passive transformations?

1089

How do you change a non-reusable transformation to reusable transformation?

1000

What is the maplet?

1127

How to generate sequence numbers?

1091