Interested to Buy Any Domain ? << Click Here >> for more details...
How do you handle decimal places while importing a flatfile
into informatica?
- 1 Answers
- 9206 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
Can u generate reports in Informatica?
what is informatica metadata?
What is incremental aggregation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How are indexes created after completing the load process?
What are multi-group transformations?
What is meant by incremental aggregation?
What are the differences between a connected lookup and unconnected lookup?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to use pmcmd utility command?
How can a transformation be made reusable?
How to update or delete the rows in a target, which do not have key fields?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Target increases every day even though no new record was inserted
