3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / upendra
large amount of data in source file.So we can devide partitions and commit level ur own wish,then connected to different target table, each one target table better for bulk load.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
What is rank transform?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Whats there in global repository
what is $$$$?
Explain the features of connected and unconnected lookup.
Briefly describe lookup transformation?
What is a snowflake schema?
Define update strategy?
Design a mapping to load the cumulative sum of salaries of employees into target table?
What is source qualifier transformation in informatica?
what is informatica metadata?
What is the difference between source qualifier transformations source filter to filter transformation?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you handle two sessions in Informatica