Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 4 Answers
- 8768 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / sai
There is no performance difference while aggregation because Order by always comes after Aggregation.
| Is This Answer Correct ? | 0 Yes | 1 No |
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 |
Answer / me
If you use sorted input and do not sort data correctly, the session fails.
| Is This Answer Correct ? | 0 Yes | 2 No |
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
What is the difference between view and materialised view?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is service oriented architecture in Informatica 8 version
1 Answers Cap Gemini, IBM, Systech, TCS,
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
my source is junk data how will u remove that junk data by using unix please any one replay me
i want excute multiple sessions in one workflow using the "start task".what do i need to do?
how to join two flat file if they have diff. structure?how to join one relational and one flat file?
what are the reusable tasks in informatica ?
11 Answers CTS, HP, IBM, TCS,
Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????
Teradata 
