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

Suppose we do not group by on any ports of the aggregator what will be the output?

817


How many input parameters can exist in an unconnected lookup?

1302


can u give example for factless fact table

5974


Name the different lookup cache(s)?

935


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

816


Can we create multiple integration service on single repository?

957


State the differences between sql override and lookup override?

872


How to extract the informatica rejected data?

1002


What are mapplets? How is it different from a Reusable Transformation?

864


How does a sorter cache works?

800


Separate from an archive server and a powerhouse?

692


what is degenerated dimension?

3522


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

853


What is the difference between a connected look up and unconnected lookup?

762


When do you use sql override in a lookup transformation?

786