3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / bakshu shaik
one more thing we need to take into consideration, along with above suggestions:
If the target having an index, Loading time (huge amount of data) increases/performance hazard......so it's always better to drop the index before loading(Stored procedure transformation) and create again after loading completed...!
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain the different lookup methods used in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
how to create user defined function (udf) in informatica
tell me 5 session failure in real time how can you solve that in your project?
How do you handle two sessions in Informatica
How to load a Dimension ? and how to load a fact table?
What is the Process to creating lookup transformation in informatica
What is the status code in stored procedure transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How does the aggregator transformation handle null values?
what is informatica metadata?
what is the size ur source like(file system or database)? how many record daily come u r banking project?