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
- 7100 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
Why update strategy and union transformations are active? Explain with examples.
What do you mean by worklet?
What do you understand by term role-playing dimension?
Explain target update override in informatica
Write the unconnected lookup syntax and how to return more than one column.
Define sessions in informatica etl?
Enlist the various types of transformations.
what is the complex transformation you used in informatica
what is the -ve test case in your project.
What is DR strategy for Informatica project?
can you please explain me pre session and post session options?
what is size of u r database?
What is an expression transformation in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
Explain the etl program with few examples.
