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
- 6816 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sree
in exp t/r u can write ltrim(id,'0')
iam giving just an idea
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
How to open an older version of an object in the workspace?
How does the aggregator transformation handle null values?
While migrating the data from one environment to another environment how would you manage the connections?
Difference between Target-based loading and constraint-based loading?
Differentiate between a database and data warehouse?
What are the different types of olap? Give an example?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain Dataware house architecture .how data flow from intial to end?
How can we delete duplicate rows from flat files?
What is an aggregator transformation?
Quickly characterize reusable change?
What are some examples of informatica etl programs?
How are indexes created after completing the load process?
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
What is a rank transform?
