Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21645 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhishek
U can achive this by using row_number function in source
qualifer example
select col1,col2,salary,emp_id from (select
col,col2,salary,emp_id , row_number() over (partition by
salary order by emp_id )as rec_seq from table)
Where
rec_seq=3
or by rank t/r in mapping
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Session and Batches?
How are the sources and targets definitions imported in informatica designer?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is the procedure for creating independent data marts from informatica 7.1?
How to extract sap data using informatica?
permutations of mapplet
Which version configuration tool used in ur project?
Design time, run time. If you don't create parameter what will happen
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 are the tasks that source qualifier perform?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What is rank transformation?
What is an aggregator transformation?
How can we handle two sessions in informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
