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
- 6969 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 |
What is primary and backup node?
What is the cumulative sum and moving sum?
How to use procedural logic inside infromatica?
design of staging area?
what are challenges that you faced in testing? give solution to it?
what are objects in data warehouse?
How to update records in Target, without using Update Strategy?
The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?
What are the different clients of powercenter?
In Which scenario did u used Incremental loading?
Explain the difference between mapping parameter and mapping variable?
How to open an older version of an object in the workspace?
Teradata 
