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
What are the uses of etl tools?
Can you use flat files in Mapplets.
Explain the aggregator transformation?
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?
Which are the different editions of informatica powercenter that are available?
Enlist the tasks for which source qualifier transformation is used.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What are Dimensional table?
How to improve the performance of a session using sorter transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What all join we can perform in LOOKUP transformation?
What are mapplets?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?