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
In which transformation you cannot drag ports into it?
Explain what are the different versions of informatica?
lookup transformation with screenshots
What are the main features of Oracle 8i with context to datawarehouse?
Whats there in global repository
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is intricate mapping?
What are multi-group transformations?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What are the different lookup cache(s)?
how to load dimension table and fact table. plz tell me the steps.
Explain what transformation and how many are there in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How do you take back up of repository?
what is $$$$?