when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?
- 3 Answers
- 5144 Views
- I also Faced
- E-Mail Answers
Answer Posted / skg
A:when you run a session with Normal load IS commits data into the target table as well as commits rowid into a log table.
For Example: you have 10000 records in your source,while loading data if your session fails at any point of time then there is a scope of recovery.After you fetch the issue when you rerun the job you need to ensure that your session is running with Normal load and instead of loading from the scratch,IS connect to the Repository service then Repo service connect to the Repo Database and check what is the last rowid commited in the log table and start loading from the max rowid+1 on wards.
checkpoint at session level: Resume From Last save heckpoint
BulkLoad: when you run a session with Bulk load the IS loads the data into target table and it won't commit any rowid into the log table. so performance will be good because only one operation is happing here but if session is failed at any point of time then there is no scope of recovery.
Note: when you work with Bulk load you need to ensure that there is no indexes on target table.if it has indexes your session get fails.
Q: I want to use bulk load and i have indexes on target table can't i access?
A: Yes you can achieve this by ensuring the option
Pre-SQL as :Drop Index index_Name;
Post-SQL as:create Index index_Name on table_Name(col_Name);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
generate date / time dimension in informatica
What is meant by incremental aggregation?
What are the types of schemas we have in data warehouse and what are the difference between them?
Define enterprise data warehousing?
What is a sequence generator transformation?
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 do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is meant by lookup transformation? Explain the types of lookup transformation?
Explian the Process of deployment groups in informatica
How are the sources and targets definitions imported in informatica designer?
What is flashback table ? Advance thanks
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
