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
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
How can we remove the duplicates from flat file source?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
How to load a Dimension ? and how to load a fact table?
how many types of dimensions are available in informatica?
What are the advantages of informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is a snowflake schema?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
How to update a particular record in target with out running whole workflow?
Explain the shared cache and re-cache?
What is lookup change?