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
- 6958 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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is informatica worklet?
how many types of dimensions are available in informatica?
Can you use flat files in Mapplets.
What are the advantages of using informatica as an etl tool over teradata?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is option by which we can run all the sessions in a batch simultaneously?
Explain the different kinds of facts.
What is the difference between source qualifier transformations source filter to filter transformation?
Different circumstance which drives informatica server to expel records?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Performance tuning in UNIX for informatica mappings?
How identifying bottlenecks in various components of informatica and resolving them?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
