Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6244 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
What are the modules in Power Center
How we can create indexes after completing the load process?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain how to import oracle sequence into informatica?
How many types of sessions are there in informatica.please explain them?
How to update or delete the rows in a target, which do not have key fields?
wf dont have integration severances how you can run?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
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?
What is meant by pre and post session shell command?
where to store informatica rejected data? How to extract the informatica rejected data?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is sq transformation?
how many types of dimensions are available in informatica?
According to his methodology what all you need before you build a datawarehouse
