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
What are junk dimensions?
Under which circumstances, informatica server creates reject files?
Performance tuning in UNIX for informatica mappings?
What are the different types of olap? Give an example?
What is informatica worklet?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What you know about transaction control transformation?
Repository user profiles
Differentiate between reusable transformation and mapplet.
Explain incremental aggregation in informatica
What is the difference between STOP and ABORT options in Workflow Monitor?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
what is index?how it can work in informatica
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 ?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?