1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

What are the different ways to implement parallel processing in informatica?

Question Posted / bishan swaroop


What are the different ways to implement parallel processing in informatica?..

Answer / Surya Pratap

"Informatica PowerCenter provides several methods for implementing parallel processing. These include: 1) Parallel Execution - splitting a transformation into multiple sub-transformations that run concurrently on different processors. 2) Concurrent Execution - executing multiple transformations simultaneously by using multiple engine sessions. 3) Pipelined Row-Based Processing - where data is processed in a pipeline fashion, reducing the time spent waiting for data to flow through the system. 4) Partitioned Load - breaking down large data sets into smaller subsets and processing them concurrently."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

2 Answers   CTS,

how can u connect client to ur informatica sever iff server is located at different place( not local to the client)

3 Answers   Accenture,

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

can any one give some examples for pre sql and post sql(Except dropping and creating index).

1 Answers   Zensar,

what is session parameters?

1 Answers   Cap Gemini,

I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,

3 Answers   CSC,

what is the location of parameter file in informatica?

1 Answers   TCS,

without update strategy how to insert &update?

1 Answers   DELL,

Mapping variables, parameters syntax, if you create mapping variables and parameters in mapplet can you use them in the mapping?

1 Answers  

how to move the mappings from your local machine to claint place?

2 Answers  

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

What are the options in the target session of update strategy transsformatioin?

2 Answers  

For more Informatica Interview Questions Click Here
Categories