Answer Posted / chandrababu.sarupuru
Partition's can be done on both relational and flat files.
Informatica supports following partitions
1.Database partitioning
2.RoundRobin
3.Pass-through
4.Hash-Key partitioning
5.Key Range partitioning
All these are applicable for relational targets.For flat
file only database partitioning is not applicable.
Informatica supports Nway partitioning.U can just specify
the name of the target file and create the partitions rest
will be taken care by informatica session.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to update a particular record in target with out running whole workflow?
What is the use of target designer?
What is the different lookup cache(s)?
What are the components of workflow manager?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is informatica etl tool?
What is difference between a gateway node and worker node?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
whats the logic to load the lower level of granularity of data to fact table.
What is a surrogate key?
What you know about transaction control transformation?
Write the different tools in the workflow manager?
How to extract the informatica rejected data?
What are the different types of repositories created using informatica?
Different qualification between a related rotate toward the sky and isolates look upward?
