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
- 7260 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is union transformation?
What are the tasks that can be performed using sq?
How to load last n records of file into target table - informatica
What is update strategy transform?
Explain how to import oracle sequence into informatica?
What is DR strategy for Informatica project?
Differentiate between reusable transformation and mapplet.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Define mapping and session?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the reusable transformations?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How do you load first and last records into target table?
r u done any partitions in ur project?
How do you manage the Parameter files while migrating your data from one environment to another environment?
