Sign Up Login


  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / charangiri.p

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / sai

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

Is This Answer Correct ?    6 Yes 0 No

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

Answer / asjad

trim(Col_Nm,'0',L)

Is This Answer Correct ?    2 Yes 4 No

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

Answer / 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

More Informatica Interview Questions

How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.

3 Answers   Amdocs,

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

how tokens will generate?

0 Answers  

I am Unable to load the FixedWith FlatFile Into The Target.What Is The Reason. PLZ Help Me..

1 Answers  

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

Different sorts of metadata that stores in the storage facility?

0 Answers  

Hi Every One,What is Use of Factless Fact Table ? Why we use Factless Fact Schema in the Projects waiting for reply? thank you

6 Answers  

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

For more Informatica Interview Questions Click Here
Categories