how can you load data into target table without leading zeor's
- 4 Answers
- 23693 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / sai
Use Exp transformation and use function
Ltrim(col_name,'0')
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain the shared cache and re-cache?
What is a standalone command task?
Describe expression transformation?
How to join three sources using joiner?
How do you load only null records into target? Explain through mapping flow.
what is the -ve test case in your project.
Mention few advantages of router transformation over filter transformation.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the difference between a repository server and a powerhouse?
What is workflow? What are the components of the workflow manager?
What are the types of caches in lookup? Explain them.
What are the tuning techniques you applied during your last project
What are the mapping parameters and mapping variables?
How does a sorter cache works?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
