what is Partitioning ? where we can use Partition?
Answer Posted / annu
Partitioning is a utility provided by informatica which
evolves nature of parallel processing on a grid or
multiprocessor database architecture. Partition means
a "thread of ETL data load in chunks". Like Unix, Multiple
data load thead will be executed parallely and sync up the
result set to one instance of Target.
For more detail of using Informatica Partitioning with
visual graphs
visit : http://informatica-tech-talk.blogspot.com/
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
what is the -ve test case in your project.
How to load a Dimension ? and how to load a fact table?
if we have a delimiters at unwanted places in a flat file how can we over come those.
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is option by which we can run all the sessions in a batch simultaneously?
What is the use of transformation?
How to generate sequence numbers using expression transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are junk dimensions?
What is a router transformation?
How to extract sap data using informatica? What is abap? What are idocs?
How do you load unique records into one target table and duplicate records into a different target table?
What's the layout of parameter file (what does a parameter file contain?)?
Explain the scenario which compels informatica server to reject files?
Design a mapping to load a target table with the following values from the above source?