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
- 7095 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
How many ways are there to do 'remove duplicate records in informatica'?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Explain the use of aggregator cache file?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Can u generate reports in Informatica?
Differentiate between Load Manager and DTM?
Write the prerequisite tasks to achieve the session partition?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the new features of informatica 9.x in developer level?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What is target load order?
Explain lookup transformation in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the meaning of decode in informatica?
