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
- 6817 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the benefit of partitioning a session?
where to store informatica rejected data?
Explain about Informatica server process that how it works relates to mapping variables?
What are the measure objects?
What do you understand by SOA of Informatica?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What are the advantages of using informatica as an etl tool over teradata?
How might you approve all mappings in the archive all the while?
What are the features of complex mapping?
How do you set a varible in incremental aggregation
What you know about transaction control transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How do you update the records with or without using update strategy?
Enlist the various types of transformations.
How to extract sap data using informatica? What is abap? What are idocs?
