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
Can we override a native sql query within informatica?
What's the layout of parameter file (what does a parameter file contain?)?
without table how to come first record only in oracle?
What will be the approach?
What are the types of schemas we have in data warehouse.
What are the types of lookup transformation?
What is the use of target designer?
what is song in infrmatica...?
What is mapplet in informatica?
What does update strategy mean, and what are the different option of it?
What are the issues you have faced in your project? How did you overcome those issues?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the different clients of powercenter?
Explain your project of banking domian.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?