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
How to load the data from people soft hrm to people soft erm using informatica?
How to load the data from a flat file into the target where the source flat file name changes daily?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
In development project what is the process to follow for an etl developer from day1
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Is there any way to read the ms excel datas directly into informatica?
Explain sql transformation in script mode examples in informatica
What do you understand by a term domain?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Briefly define a session task?
Why filter transformation is an active one?
What is the need of an ETL tool?
How do you handle two sessions in Informatica
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project