My source table look like
ID Name Location Salary
0000001 ran tpty 1000
0000002 ram DELHI 2000
hju-hji raj hyd 1000
my target table should be
ID Name Location Salary
1 ran tpty 1000
2 ram DELHI 2000
hju-hji raj hyd 1000
Answer Posted / xyz
in expression t/r use replace(id,'000000','')
Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Mention few power centre client applications with their basic purpose?
What is sequence generator transformation in informatica?
What is a router transformation?
What is a passive transformation?
What can we do to improve the performance of informatica aggregator transformation?
Clarify the aggregator change?
Enlist the various types of transformations.
How to implement security measures using repository manager?
What is data movement mode in Informatica and difference between them?
Define Pmrep command?
What is rank transformation?
tell me about your project functionality
How to elaborate tracing level?
How we can use union transformation?
Write the advantages of partitioning a session?