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

Answer Posted / maruthi

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

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define filter transformation?

890


What is informatica powercenter repository?

952


Can we create a Integration service without a Repository service and vice versa?

1016


What is the sql query overwrite in source qualifier in informatica

859


Differentiate between source qualifier and filter transformation?

1304


Explain the difference between a data warehouse and a data mart?

834


what is mean by complex business rule ?

1924


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

898


Partition, what happens if the specified key range is shorter and longer

2244


without table how to come first record only in oracle?

2064


What are ETL Tools?

874


What are the uses of etl tools?

892


How to open an older version of an object in the workspace?

878


Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2132


What are the tuning techniques you applied during your last project

1803