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
- 6815 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / xyz
in expression t/r use replace(id,'000000','')
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
Describe an informatica powercenter?
What is a joiner transformation and why it is an active one?
Where do we use mapping variables in informatica?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
explain abt ur project architecture?
Is it possible to create multiple domains on a single Informatica server?
What is domain and gateway node?
How to update source definition?
What is xml source qualifier transformation in informatica?
Differentiate between Load Manager and DTM?
Differentiate between joiner and lookup transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is joiner transformation in informatica?
What is a snowflake schema?
What is meant by lookup transformation? Explain the types of lookup transformation?
