how can you load data into target table without leading zeor's
Answer Posted / asjad
trim(Col_Nm,'0',L)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Can we create multiple integration service on single repository?
What are the components of the workflow manager?
if we have a delimiters at unwanted places in a flat file how can we over come those.
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 do you mean by enterprise data warehousing?
Enlist the tasks for which source qualifier transformation is used.
What are the advantages of informatica?
I have a flat file, want to reverse the contents of the flat file
Can we change Dynamic to Static or Persistent cache? If so what happens?
Target increases every day even though no new record was inserted
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the components of Informatica? And what is the purpose of each?
explain about unit testing? in real time?
Describe expression transformation?
Difference between Data and Index Caches?