Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3 Answers
- 6923 Views
- TCS, I also Faced
- E-Mail Answers
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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How are indexes created after completing the load process?
What is meant by pre and post session shell command?
Can we get 1st record through Informatica(without sequence number).
Different sorts of metadata that stores in the storage facility?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
What is the use of target designer?
How to extract sap data using informatica? What is abap? What are idocs?
In informatica workflow manager, how many repositories can be created?
Enterprise data warehouse your projects phase by phase explain?
What are the types of lookup transformation?
Mention a few design and development best practices for informatica?
What is data movement mode in Informatica and difference between them?
Is there any way to read the ms excel datas directly into informatica?
