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
Which transformation should we use to normalise the COBOL and relational sources?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is blocking transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
What is sq transformation?
EXL informatica Questions
Do you find any difficulty while working with flat files as source and target?
lookup transformation with screenshots
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Differentiate between reusable transformation and mapplet.
What is a mapplet/worklet in informatica?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How you prepared reports for OLAP?
Explain why we use partitioning the session in informatica?