3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / james
I agree with you Chinni.
But my suggestion is instead of loading huge amount of data
at a time,we can always split the source if it is a file
using unix and extract the data from all the source files
using indirect type and load into target.
Please let me know if you have any suggestions.
Thanks.
James.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Partition, what happens if the specified key range is shorter and longer
What is a sorter transformation?
What are the informatica performance improvement tips
Mention few advantages of router transformation over filter transformation.
What is blocking transformation?
Why sorter is an active transformation?
Tell me about Propagate functions in informatica
What are the components of Informatica? And what is the purpose of each?
What is expression transformation?
Write the program through which the records can be updated?
What is decode in static cache?
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 ?
Under what condition selecting sorted input in aggregator may fail the session?
What is a joiner transformation?