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 |
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is a parameter When and where do you them when does the value will be created
Without source how to insert record to target?
what is degenerated dimension
What is a data modeling?
how to read data from website into informatica? plsss send answers ASAP thanks in advance.
how remove 1st 3 records & last 3 records in informatics
what is SDLC way of code development?
how can we use sorter transformation in joins?
How identifying bottlenecks in various components of informatica and resolving them?
When the informatica server marks that a batch is failed?