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



My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ..

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

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ..

Answer / xyz

in expression t/r use replace(id,'000000','')

Is This Answer Correct ?    5 Yes 4 No

My source table look like ID Name Location Salary 0000001 ran tpty 1000 0000002 ..

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

Post New Answer

More Informatica Interview Questions

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,


What is workflow? What are the components of the workflow manager?

0 Answers  


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

1 Answers   HP,


in performance wise union is past,union all is past

2 Answers  


what is the monster dimension plz give me one example

2 Answers   EDS,






Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


what is flat file override?

1 Answers   Cap Gemini, HP,


While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  


What is a rank transform?

0 Answers  


What is decode in static cache?

0 Answers  


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

2 Answers  


How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,


Categories