Interested to Buy Any Domain ? << Click Here >> for more details...
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 ??
- 2 Answers
- 6178 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is the difference between Power Centre and Power Mart?
How will you check the bottle necks in informatica? From where do you start checking?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How Union Transformation is an Active Trans?
Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that
wt is Dynamic lookup Transformation? when we use?how we use?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
What is the capacity of power cube?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000
how u know when to use a static cache and dynamic cache in lookup transformation.
Which means the first record should come as last record and last record should come as first record and load into the target file?
Teradata 
