Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 25083 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 is confirmed fact in dataware housing?
how the informatica server sorts the strings values in rank transformations?
Partition, what happens if the specified key range is shorter and longer
What is the difference between router and filter?
whether Sequence generater T/r uses Caches? then what type of Cache it is
What is IQD file?
What are the types of maping wizards that r to be provided in Informatica?
"Change cache" in Informatica ?
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
How can you display only hidden files in UNIX
difference between informatica 8.1.1 and 8.6
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?
Teradata 
