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 convert multiple rows to single row (multiple columns) in informatica
Why do you use Mapping Parameter and mapping variable?
Which transformation should we use to normalise the COBOL and relational sources?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is status code in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What are the differences between oltp and olap?
Explain pmcmd command usage in informatica
Explain direct and indirect flat file loading (source file type) - informatica
Explain sql transformation in script mode examples in informatica
Explain the pipeline partition with real time example?
What is the reusable transformation?
Define the various join types of joiner transformation?