Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between normal and bulk loading?
Which one is recommended?
- 1 Answers
- 5936 Views
- I also Faced
- E-Mail Answers
Answer / rakesh
The main difference between normal and bulk load is, in normal load Informatica repository service create logs and in bulk load log is not being created. That is the reason bulk load loads the data fast and if anything goes wrong the data can not be recovered. But in normal load since the log is created the lost data can be recovered.
By configuring session to Bulk loading we cannot do 'session recovery' when it get failed whereas in normal loading we can easily do session recovery.
Note:In normal load Informatica creates logs record by record in database level and in bulk mode it will not create detail log. By avoiding that detail writing in bulk mode improve performance.
Note:If there are indexes and constraints in the table, you cannot use Bulk Load
You can drop/disable those indexes/constraints (pre session ) , then load the data (use Bulk Load) , and then create/enable the indexes/constraints (post session )
| Is This Answer Correct ? | 14 Yes | 0 No |
Explain the features of connected and unconnected lookup.
How can we update a record in the target table without using update strategy?
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
why we use materialized view over view?
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
How to load data in informatica ?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
my source has 2 columns. 1st column data: ABC ABC ABC XYZ and 2nd column data: 1 2 3 4. And my target should be ABC 1 2 3, XYZ 4
How can a transformation be made reusable?
In ur current projectu have done any performance tuning of mappings?
How to eliminate 1st and last rows from the source and load the inbetween rows.
Teradata 
