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 / sree
in exp t/r u can write ltrim(id,'0')
iam giving just an idea
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
How can you generate reports in informatica?
which one is better performance wise joiner or look up
What are the types of presistent cache in look up tr.
How can you differentiate between powercenter and power map?
On which transformations you created partitions in your project?
What is a router transformation?
What happens when a session fails and you click on recover?
How can we store previous session logs?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the way to execute pl/sql script using informatica mapping?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
Explain load alternative records / rows into multiple targets - informatica
Is stop and abort are same in informatica?
What is rank transformation in informatica