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 |
what is index?how it can work in informatica
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
If we set dd_insert in mapping and Delete in session properties what will happen.?
Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,result > 1, ak, 80,p > 2, , ,20,f > 3,jack,55,p > > now in the second row a comma(,) is placed instead of name(char). > > when importing into SQ , in flat file wizard the num of columns increased to 5 instead of 4. > > could you tell me how to over come this issue.........
Why update strategy and union transformations are active?
Repository user profiles
What is a unit Testing?
what is mapping parameter?
what is the main advantage of unconnected lookup
how lookup is acting as both active and passive ? how is it possitble?