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
tell me 5 session failure in real time how can you solve that in your project?
define galaxy repository in informatica
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?
What are the measure objects?
Explian the Process of deployment groups in informatica
Define sessions in informatica etl?
What is fact table? Explain the different kinds of facts.
What is olap (on-line analytical processing?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Where is metadata stored?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a node in Informatica?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is the difference between informatics 7x and 8x and what is latest version?