How do you handle decimal places while importing a flatfile
into informatica?



How do you handle decimal places while importing a flatfile into informatica?..

Answer / maruthi

1.)use to_integer('column name','newcolumn)
it works

Is This Answer Correct ?    6 Yes 4 No

Post New Answer

More Informatica Interview Questions

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,


Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,


What are the parts of Informatica Server?

1 Answers   Cognizant,


How will you update the row without using update statergy?

10 Answers   CTS,


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,






can anyone explain me about sales project in informatica?

8 Answers   MBT, Satyam,


Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,


How might you approve all mappings in the archive all the while?

0 Answers  


How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,


how do u tune queries?

1 Answers  


What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,


What is exclusive and normal mode for repository services?

0 Answers  


Categories