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
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 |
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What is workflow? What are the components of the workflow manager?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
in performance wise union is past,union all is past
what is the monster dimension plz give me one example
Where is the cache stored in informatica?
what is flat file override?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is a rank transform?
What is decode in static cache?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
How can yoU improve session performance in aggregator transformation?