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 / rakesh
Hi,
Use trim(leading '0' from '00001') option
Please let me know if i am wrong
Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is joiner change?
What are active and passive transformations?
What does update strategy mean, and what are the different option of it?
Enlist the tasks for which source qualifier transformation is used.
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Describe expression transformation?
can we override a native sql query within informatica? How do we do it?
Explain the pipeline partition with real time example?
What is meant by LDAP users?
Can we create multiple integration service on single repository?
On which transformations you created partitions in your project?
What is the cumulative sum and moving sum?
How to generate sequence numbers using expression transformation?