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
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to go to the older version for a mapping?
Write the program through which the records can be updated?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the different ways to implement parallel processing in informatica?
What are the components of workflow manager?
What is the session task and command task?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
While migrating the data from one environment to another environment how would you manage the connections?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
How are the sources and targets definitions imported in informatica designer?
What is a predefined event?
What is the use of source qualifier?
What is DR strategy for Informatica project?