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

What are pre and post-session shell commands?

1279

What is the difference between writing a joiner query in ANSI style and THETA style?

2364

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1259

How can we improve session performance in aggregator transformation?

1086

How to load last n records of file into target table - informatica

1049

What is difference between a gateway node and worker node?

1110

Write the unconnected lookup syntax?

1064

What is a stored procedure transformation?

1033

What is main use of mapplet?

1118

What are multi-group transformations?

1062

During the running session, output files are created by informatica server. Enlist few of them.

966

Can we create multiple integration service on single repository?

1171

What is the function of union transformation?

1107

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1072

What is informatica worklet?

1027