what is Partitioning ? where we can use Partition?
- 2 Answers
- 22434 Views
- IBM, TCS, I also Faced
- E-Mail Answers
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
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
what is the difference between informatica6.1 and infomatica7.1
What are mapplets? How is it different from a Reusable Transformation?
What is lookup transformation?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Write the program through which the records can be updated?
Can you use flat files in Mapplets.
What is a filter transformation?
what is mean by complex business rule ?
How to update a particular record in target with out running whole workflow?
What is complex mapping?
Mention few advantages of router transformation over filter transformation.
draw informatica architecture 8.6 ?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What are different types of transformations available in informatica?
