3,if our source containing 1 terabyte data so while loading
data into target what are the thing we keep in mind?
Answer Posted / vasu
Always Partition is the best option for huge volume
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
what is the hint? how to use it to reduce the query processing in program?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the different versions of informatica?
What are the designer tools for creating transformations?
How many input parameters can exist in an unconnected lookup?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Differentiate between source qualifier and filter transformation?
How can we update a record in the target table without using update strategy?
lookup transformation with screenshots
which one is better performance wise joiner or look up
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How do you load unique records into one target table and duplicate records into a different target table?
How to create a non-reusable instance of reusable transformations?