Use Exp transformation and use function Ltrim(col

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

Question Posted / sai

Answer Posted / sai

Use Exp transformation and use function
Ltrim(col_name,'0')

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are roles and groups and benefits of using them?

1055

What are the different versions of informatica?

1260

What is repository manager?

984

Why sorter is an active transformation?

1187

lookup transformation with screenshots

4002

How to create Target definition for flat files?

1212

Difference between Target-based loading and constraint-based loading?

995

Describe an informatica powercenter?

1124

Briefly explain the aggregator transformation?

994

What does command task mean?

1138

have u done any performance tuning? how u ll do?

2296

Explain the types of lookup transformation?

1042

What is decode in informatica?

1148

Describe data concatenation?

1074

is it possible to index the data in cache of lkp transformation ?

2026