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
my source is junk data how will u remove that junk data by using unix please any one replay me
What is a predefined event?
What is the cumulative sum and moving sum?
Parameter and variable differences
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the use of transformation?
What are pre and post-session shell commands?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
What is meant by lookup transformation?
What are some examples of informatica etl programs?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
How you know when to use a static cache and dynamic cache in lookup transformation?
What are the reusable transformations?
How we can use union transformation?