Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / aswin
Its purely depending on the way the design involved..Recovery strategy is not possible with flatfile targets..If commit happens inbetween, there is no point in running session from beginning
so manual intervention is required to restat the flatfile target load fails
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What are the new features of informatica 9.x developer?
What's the layout of parameter file (what does a parameter file contain?)?
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
What is the function of aggregator transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is domain and gateway node?
On which transformations you created partitions in your project?
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
what is index?how it can work in informatica
Define enterprise data warehousing?
Explain how many types of dimensions are available in informatica?
What is informatica metadata and where is it stored?
What is a node in Informatica?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
