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
- 6974 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 are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
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 can you access the remote source into your session?
In how many ways we can create ports?
how to design mapping half of source table records into one target and remaining half into another target
Target increases every day even though no new record was inserted
How can we use mapping variables in informatica? Where do we use them?
what is threshold error in informatica?
How many number of sessions that u can create in a batch?
Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
Teradata 
