what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
Answer Posted / ravikumar2614
Rank creates gaps where as densc Rank will not create gaps(between two ranks).
1st answer is correct
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What is meant by incremental aggregation?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
hi real timers . iam waiting for ur reply regarding ETL TESTING
expain about the tune parameters?
How to update a particular record in target with out running whole workflow?
What is parallel processing in informatica?
How to configure mapping in informatica?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is main use of mapplet?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Mention few advantages of router transformation over filter transformation.
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Describe the impact of several join conditions and join order in a joiner transformation?