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
- 5110 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
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Have you worked with/created Parameter file
What is resilience time?
What happens when a session fails and you click on recover?
what is the size of your data warehousing?
what is INFORMATICA TESTING process
Please let me know how to make Data masking in informatica..
Explain Dataware house architecture .how data flow from intial to end?
According to his methodology what all you need before you build a datawarehouse
What is a filter transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What are the designer tools for creating transformations?
what is SDLC way of code development?
what is the size ur source like(file system or database)? how many record daily come u r banking 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
