Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shankar mahadevan
The Designer creates a RANKINDEX port for each Rank
transformation. The Integration Service uses the Rank Index
port to store the ranking position for each row in a group.
For example if a Rank transformation is created on the top
five salespersons for each quarter
(Matrix being Sales Person and Measure is Sales) Criterion
Top or bottom (Quarter is a time based dimension)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How many number of sessions can one group in batches?
What are active and passive transformations?
where to store informatica rejected data?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the way to execute pl/sql script using informatica mapping?
What is the sql query overwrite in source qualifier in informatica
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?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
generate date / time dimension in informatica
How many dimensions are there in informatica?
Describe data concatenation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is the use of target designer?
write a query to retrieve the latest records from the table sorted by version(scd)
What does refresh system mean, and what are its distinctive choice?
