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
- 6967 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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is status code in informatica?
How might you approve all mappings in the archive all the while?
What is the advantage of informatica?
Explain the informatica workflow?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Enlist the various types of transformations.
What is informatica worklet?
In development project what is the process to follow for an etl developer from day1
How many ways a relational source definition can be updated and what are they?
In warehouses how many schemas are there?
Can informatica load heterogeneous targets from heterogeneous sources?
How to delete duplicate row using informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
