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


Please Help Members By Posting Answers For Below Questions

Performance tuning( what you did in performance tuning)

1477


Explain how to import oracle sequence into informatica?

581


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

624


What is the benefit of partitioning a session?

617


What is xml source qualifier transformation in informatica?

707






What is parallel processing in informatica?

1017


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

589


Which is the t/r that builts only single cache memory?

697


What is Session and Batches?

654


What are roles and groups and benefits of using them?

561


How can we use mapping variables in informatica?

592


What do you understand by a term domain?

658


What does command task mean?

602


Explain the different dimensions.

546


Which transformation is needed while using the Cobol sources as source definitions?

719