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
- 6968 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 Data Caches size?
What is a sequence generator transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
How do we call shell scripts from informatica?
What do you mean by channel change?
What is the command used to run a batch?
What is confirmed fact in dataware housing?
What is the fact table?
Explain the mapping variable usage example in informatica
Separate from a database, an information bazaar, and an information stockroom?
Why update strategy and union transformations are active? Explain with examples.
How union transformation is used?
What is the difference between a repository server and a powerhouse?
What will be the approach?
