Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 24727 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What if the source is a flat-file?
What are the main issues while working with flat files as source and as targets ?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What are the measure objects?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the Rank index port in Rank transformation?
What do think which one is the better joiner or look up?
What are the different ways to implement parallel processing in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
Write the advantages of partitioning a session?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How to update source definition?
