Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 24937 Views
- Deloitte, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srini
By using the Trim function we can able to Remove the
leading Zero's in a value and we can load it in to target.
Function : trim(Col_Nm,'0',L)
| Is This Answer Correct ? | 12 Yes | 2 No |
Answer / sai
Use Exp transformation and use function
Ltrim(col_name,'0')
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / abhinaw prakash
We can use Replace function as well to remove the zeroes
before loading the data into the target
| Is This Answer Correct ? | 0 Yes | 7 No |
What do you understand by term role-playing dimension?
What is Performance tuning in Informatica?
explain abt union t/r?
WHat all joins are there in Source Qualifier?
What is the different lookup cache(s)?
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
State the differences between sql override and lookup override?
what is the drillup & drill down?and use of the drill up and drill down?
What is up date strategy and what are the options for update strategy?
How do you handle decimal places while importing a flatfile into informatica?
what is update strategy transformation ?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
Teradata 
