how can you load data into target table without leading zeor's
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
Why filter transformation is an active one?
During the running session, output files are created by informatica server. Enlist few of them.
What is meant by lookup transformation?
Explain what transformation and how many are there in informatica?
generate date / time dimension in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Define the various join types of joiner transformation?
How big was your fact table
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How can we use mapping variables in informatica? Where do we use them?
What are the measure objects?
Parameter and variable differences
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Define filter transformation?
Explain the aggregator transformation?