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
How to configure mapping in informatica?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Do you find any difficulty while working with flat files as source and target?
What differs when we choose the sorted input for aggregator transformation?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Differentiate between sessions and batches?
Is there any way to read the ms excel datas directly into informatica?
What is the difference between informatica 7.0 and 8.0?
What are junk dimensions?
what are the deliverables?in your project?
can we override a native sql query within informatica? Where do we do it?
What is the Process to creating lookup transformation in informatica
In informatics server which files are created during the session rums?
How many ways a relational source definition can be updated and what are they?
What are the differences between source qualifier and joiner transformation?