Interested to Buy Any Domain ? << Click Here >> for more details...
how can you load data into target table without leading zeor's
- 4 Answers
- 25084 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
Enlist the tasks for which source qualifier transformation is used.
can we override a native sql query within informatica? Where do we do it?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you handle two sessions in Informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How to load data in informatica ?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Enlist the various types of transformations.
How to start a workflow using pmcmd command?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is target load order?
Differentiate between Load Manager and DTM?
What is the different lookup cache(s)?
Briefly define a session task?
