By using the Trim function we can able to Remove the leading Zero's

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

Question Posted / srini

Answer Posted / srini

By using the Trim function we can able to Remove the
leading Zero's in a value and we can load it in to target.
Function : trim(Col_Nm,'0',L)

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2117

How do you load only null records into target? Explain through mapping flow.

2015

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8218

What are the data movement modes in informatica?

1145

How to Create a folder using pmrep command?

1173

What is the need for an etl tool?

1064

What is the use of code page?

1085

What do you understand by SOA of Informatica?

981

Write the unconnected lookup syntax and how to return more than one column.

1107

Differentiate between reusable transformation and mapplet.

1086

what is the size of u r source(like file or table)?

2268

can we override a native sql query within informatica? Where do we do it?

1114

What is sq transformation?

1158

How union transformation is used?

1002

What is update strategy transform?

1096