3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / chinni
1tera data is huge amount of data so if we use normal load
type it takes so much of time....to overcome this better to
use bulk loading...and also taking the large commit
intervals we can get good performance....and one more
technique is external loading.....
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
What is dimensional table?
What is the meaning of up gradation of repository?
How do you set a varible in incremental aggregation
What is DR strategy for Informatica project?
how to load dimension table and fact table. plz tell me the steps.
What do you understand by a term domain?
What are the popular informatica products?
Define update strategy?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to load the data from people soft hrm to people soft erm using informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Differentiate between router and filter transformation?
What are the different types of olap? Give an example?
How to do the error handling of if ur source is flatfiles?
What is domain in terms of informatica?