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

What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall?

Please answer below. thank you.

Question Posted / pradeep

Answers were Sorted based on User's Feedback



What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / harish

No performance downfall. Example: if your choosing sort order on deptno asc/desc and sal desc.

Is This Answer Correct ?    0 Yes 1 No

What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / sai

There is no performance difference while aggregation because Order by always comes after Aggregation.

Is This Answer Correct ?    0 Yes 1 No

What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / bharath yadav

after sorting data in sorter tf enable sorted input in aggregator tf for better performance . if the sorted data key in sorter tf and aggregator tf differs then session fails.

Is This Answer Correct ?    0 Yes 1 No

What if we sort the data in descending order instead of increasing order in sorter t/f and send the ..

Answer / me

If you use sorted input and do not sort data correctly, the session fails.

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

6 Answers   CTS, Wipro,

What is pmcmd command?

0 Answers  

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,




111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,

How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

What is the sql query overwrite in source qualifier in informatica

0 Answers   Informatica,

How many ways are there to create ports?

0 Answers   Informatica,

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

what is the need of session partitioning... how it is useful in real time

3 Answers   Amazon,

For more Informatica Interview Questions Click Here
Categories