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

How identifying bottlenecks in various components of informatica and resolving them?

686


Explain sessions. Explain how batches are used to combine executions?

694


What is rank transform?

675


What is meant by lookup transformation?

698


Which development components of informatica have the highest usage?

694






Separate from a database, an information bazaar, and an information stockroom?

702


How to create the source and target database connections in server manager?

710


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1720


What is a pre-defined event and user-defined event?

669


Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1828


What are the different types of transformation available in informatica.

725


explain one complex mapping with logic? sales project?

6288


What is a repository? And how to add it in an informatica client?

773


can u give example for factless fact table

5737


What is meant by a domain?

744