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
What do you mean incremental aggregation?
What is a standalone command task?
what is SDLC way of code development?
scenario where i can use only concurrent execution of workflow.
Explain constraint based loading in informatica
can you please explain me pre session and post session options?
What are the types of schemas we have in data warehouse.
What is the function of look up transformation?
What the difference is between a database, a data warehouse and a data mart?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How do we call shell scripts from informatica?
explan ur project architecture?
Define mapplet?
On which transformations you created partitions in your project?