Interested to Buy Any Domain ? << Click Here >> for more details...
How to find from a source which has 10,000 records, find the
average between 500th to 600th record?
- 3 Answers
- 9033 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhar
Your answer is correct for the flat files. But the RElation
query you have given won't give any records.
the Query should like this
select avg(sal) from
(select emp_id, sal, rownum rnum from (
select emp_id,sal from emp order by sal desc) )where rnum
between 500 and 600
Might be this Query can be simplified with Rank option in
Oracle.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is an aggregator transformation?
What do you mean by enterprise data warehousing?
In development project what is the process to follow for an etl developer from day1
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
How will the document be delivered to me?
write a query to retrieve the latest records from the table sorted by version(scd)
What are the new features of Power Center 5.0?
What are pre and post-session shell commands?
How can you differentiate between powercenter and power map?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
explain one complex mapping with logic? sales project?
Can we create multiple integration service on single repository?
