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 |
Why use the lookup transformation ?
Useful UNIX commands regular/frequently used
what is the mechanism of the Master-Detail joining condition?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
In Which scenario did u used Incremental loading?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
How can we eliminate duplicate rows from flatfile,explain?
What is the procedure to load the fact table.Give in detail?
What are conformed dimensions?
What is a command that used to run a batch?
can u explain me banking domain projects ? and in banking domain projects how many dimension tables and how many fact tables and how to load source and targets in mapping level plese expain give me one example?
1 Answers Accenture, Cognizant, HCL, IBM, iGate, L&T, TCS, Virtusa,
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?