Why we use partitioning the session in informatica?

Answers were Sorted based on User's Feedback



Why we use partitioning the session in informatica?..

Answer / swetha

Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.

Is This Answer Correct ?    14 Yes 8 No

Why we use partitioning the session in informatica?..

Answer / honey

The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is informatica metadata and where is it stored?

0 Answers  


if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,


Name 4 output files that informatica server creates during session running?

1 Answers  


Which transformation should u need while using the cobol sources as source defintions?

2 Answers  


What is mapplet and a reusable transformation?

2 Answers  


what is work of PUSH DOWN option

2 Answers   Wipro,


hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,


What are the limitations of joiner transformation?

0 Answers   Informatica,


what happens when a batch fails?

3 Answers  


Do you find any difficulty while working with flat files as source and target?

0 Answers  


How many ways are there to do 'remove duplicate records in informatica'?

0 Answers  


I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  


Categories