111111111111ravi11111111kumar11111111111?
i want display ravi kumar using sql?
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 |
Post New Answer View All Answers
What are session parameters ? How do you set them?
How can we handle two sessions in informatica?
What is a node in Informatica?
Explain about Informatica server process that how it works relates to mapping variables?
where to store informatica rejected data? How to extract the informatica rejected data?
What does refresh system mean, and what are its distinctive choice?
Clarify the aggregator change?
Define joiner transformation?
What is meant by pre and post session shell command?
What is a joiner transformation?
Can anyone tell me the new features in Informatica 9 Version?
update strategy transformation in informatica
What is mapping debugger?
What are the steps involved in the migration from older version to newer version of Informatica Server?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?