How do you handle decimal places while importing a flatfile
into informatica?
- 1 Answers
- 8921 Views
- I also Faced
- E-Mail Answers
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
Define filter transformation?
What is informatica powercenter repository?
Can we create a Integration service without a Repository service and vice versa?
What is the sql query overwrite in source qualifier in informatica
Differentiate between source qualifier and filter transformation?
Explain the difference between a data warehouse and a data mart?
what is mean by complex business rule ?
can we override a native sql query within informatica? Where do we do it?
Partition, what happens if the specified key range is shorter and longer
without table how to come first record only in oracle?
What are ETL Tools?
What are the uses of etl tools?
How to open an older version of an object in the workspace?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What are the tuning techniques you applied during your last project
