Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 24780 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 |
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Can you copy the session to a different folder or repository?
What is powercenter on grid?
What is an Integration service in Informatica?
What is the difference between normal and bulk loading? Which one is recommended?
How to load the source table into flat file target(with columns) in informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Define maping and sessions?
What is limitations of truncate and load option
I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?
We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?
Teradata 
