how can you load data into target table without leading zeor's
- 4 Answers
- 23691 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 |
Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com
how to we create datamart?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
What is the difference between OLTP and ODS?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
How to import oracle sequence into Informatica?
What is Micro Strategy? Why is it used for?
What is Collect performance data in informatica and what is the use of it.
what is the complex transformation you used in informatica
In which circumstances that informatica server creates Reject files?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
Teradata 
