What are the rank caches?
Answers were Sorted based on User's Feedback
Answer / swetha
During the session ,the informatica server compares an inout
row with rows in the datacache. If the input row out-ranks a
stored row, the informatica server replaces the stored row
with the input row. The informatica server stores group
information in an index cache and row data in a data cache.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / shashiall
Swetha answer is correct.Expanding little bit with example.
If there r 3 same salaries..Rank will eliminate the
sequences..try this...rank will come 1,2,3,3,3,6..
To confirm this go to the SQL editor and check this with
Dense rank()function.
Is This Answer Correct ? | 2 Yes | 0 No |
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
What are the circumstances that infromatica server results an unreciverable session?
what is the process we used in joiner transformation,there is no matching column in sources?
What is Collect performance data in informatica and what is the use of it.
Mention few advantages of router transformation over filter transformation.
What all are steps in up gradation of Informatica server?
Explain the features of connected and unconnected lookup.
What are the differences between joiner transformation and source qualifier transformation?
Is there any model difference between ODS and DWH
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?