Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??

Question Posted / palthepu_santosh

Answers were Sorted based on User's Feedback



We can achieve better perfomance using sorter before an aggragator. Then what is the significance o..

Answer / guest

Typo error in my previous post.

Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the Aggregation Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    11 Yes 0 No

We can achieve better perfomance using sorter before an aggragator. Then what is the significance o..

Answer / guest

Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  

can session assigned multiple mappings or not?

2 Answers   Zensar,

how i will stop my workflow after 10 errors

2 Answers   HP,

What is target designer and target load order?

0 Answers  

How to recover sessions in concurrent batches?

3 Answers  

Difference Between ETL & ELT?

1 Answers   TCS,

suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer

5 Answers   ITC Infotech, TCS,

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.

5 Answers  

what is unit testing?tell me proceedure

0 Answers   L&T, UST,

What is the Difference between DSS & OLTP?

5 Answers  

For more Informatica Interview Questions Click Here
Categories