how can you load data into target table without leading zeor's

Answer Posted / abhinaw prakash

We can use Replace function as well to remove the zeroes
before loading the data into the target

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Make a note of the quantity vaults made in informatica?

547


In warehouses how many schemas are there?

577


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9157


How to generate sequence numbers?

612


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?

548






Mention some types of transformation?

602


What are the differences between a connected lookup and unconnected lookup?

641


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4767


What is the procedure for creating independent data marts from informatica 7.1?

559


What is the difference between a connected look up and unconnected lookup?

566


What is the command used to run a batch?

570


Under which circumstances, informatica server creates reject files?

589


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1228


What is the use of source qualifier?

662


How can we use mapping variables in informatica? Where do we use them?

616