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
- 6348 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sree
in exp t/r u can write ltrim(id,'0')
iam giving just an idea
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / 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 |
Why union transformation is an active transformation?
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
What do you mean by worklet?
How i can upload the MainFrame source For Informatica ?
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
What is the difference b/w natural key and surrogate key
what are cost based and rule based approaches and what is the difference?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is the function of look up transformation?
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
Differentiate between source qualifier and filter transformation?
To achieve the session partition what r the necessary tasks u have to do?
Teradata 
