what are the transformations that restricts the partitioning
of sessions?



what are the transformations that restricts the partitioning of sessions?..

Answer / swetha

Advanced External procedure tranformation and External
procedure transformation: This transformation contains a
check box on the properties tab to allow partitioning.

Aggregator Transformation: If you use sorted ports you can
not parttion the assosiated source

Joiner Transformation : yoU can not partition the master
source for a joiner transformation

Normalizer Transformation

XML targets.

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More Informatica Interview Questions

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 Answers  


What is Target Update Override? What is the Use ?

8 Answers   Patni,


lookup transformation with screenshots

0 Answers   TCS,


which quality process u can approach in ur project

1 Answers   CTS,


What is the benefit of session partitioning?

0 Answers  






pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

4 Answers   Magna Infotech,


If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,


When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?

3 Answers   IBM,


What are the different types of transformation available in informatica.

0 Answers  


Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  


Categories