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
- 5876 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sree
in exp t/r u can write ltrim(id,'0')
iam giving just an idea
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / rakesh
Hi,
Use trim(leading '0' from '00001') option
Please let me know if i am wrong
| Is This Answer Correct ? | 0 Yes | 4 No |
select count(1) from emp? what is the o/p?
What are differences between Informatica 7.1 and 6.1
What exactly mentioned in High level design document.can somebody explain me sequentialy.
How can you differentiate between powercenter and power map?
What are the joiner caches?
Differentiate between a repository server and a powerhouse?
what is dimension table?
How to recover the standalone session?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
Slowly changing dimensions, types and where will you use them
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
What are the basic needs to join two sources in a source qualifier?
Teradata 
