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
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is the need of an ETL tool?
What is the function of union transformation?
Which files are created during the session rums by informatics server?
have u done any performance tuning? how u ll do?
How can we improve session performance in aggregator transformation?
What is rank transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is sq transformation?
Explain informatica architecture - version 8 / 9
Briefly describe lookup transformation?
How we can use union transformation?
What is depict expression change?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Explain 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?