explain about session partitions ?
Answer / 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 |
What are the different types of olap? Give an example?
How does a rank transform differ from aggregator transform functions max and min?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail
What are the tasks that source qualifier performs?
What is blocking transformation?
where actually the usage of push down optimization happens...
I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have, source having 10records. Same with incrementally. Please answer me ASAP.
Three date formats are there . How to change these three into One format without using expression transformation ?
write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
What are the unsupported repository objects for a mapplet?