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
- 6920 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
What is the use of target designer?
What is an Integration service in Informatica?
what is the complex transformation you used in informatica
What is the procedure for creating independent data marts from informatica 7.1?
What is a filter transformation and why it is an active one?
Which transformation should we use to normalise the COBOL and relational sources?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is Data Caches size?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How many ways a relational source definition can be updated and what are they?
Scheduling properties,whats the default (sequential)
What is a repository? And how to add it in an informatica client?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the popular informatica products?
What is different between the data warehouse and data mart?
