how can you load data into target table without leading zeor's
- 4 Answers
- 23330 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 |
can we load the data with out a primary key of a table? what is target plan?
How do you handle decimal places while importing a flatfile into informatica?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
how to get max value record into one target and remaining records into another target?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
Can you copy the session to a different folder or repository?
Can we make worklet inside worklet?
How to retrieve last two days updated records?
how we load the data from source to staging area
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
what is materialized view?
How will you display "Mr" for male & "Mrs" for female in target table?
Teradata 
