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

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

Question Posted / guest

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

More Informatica Interview Questions

whats the logic to load the lower level of granularity of data to fact table.

what are the row and column separations in Flat Files

What is confirmed fact in dataware housing?

what is the mechanism of the Master-Detail joining condition?

Difference between session variables and workflow variables?

How do you load only null records into target?

How do you recover rows from a failed session

i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

What is target designer and target load order?

What is souce qualifier transformation it is active or passive

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

For more Informatica Interview Questions Click Here