Answer / guest

In the sql override, add a column for rownum which
generates the sequence numbers. Pass them into a filter
transformation to filter the records between 500 and 600.
And do the required aggregation through Aggregator
Transformation.

Through SQL :

select avg(sal) from (select id,name,sal,rownum r from
table_name )
where r between 500 and 600;

Hope this works..... if not please let me know

Answer / 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.

Answer / krishna

first u take the source,if it is flat file or relational
table then using exp t/r create one variable port.the port
like v.
increment the v value for every record .
after u write the condition in filter t/r v>=500 and v<=600

After use agg t/r and select the group by port as sal and
write the agg function avg(sal).After give the output that
port to target table

if it is relational table then use direct query in sql over
ride in source qualifier itself like


SELECT * FROM <TABLE NAME> WHERE ROWNUM>=500 AND
ROWNUM<=600

What is hash partition?

1 Answers  

---

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

---

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?

0 Answers   HP,

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

0 Answers   HCL,

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

what are the challenge face in u r project?explain me

1 Answers   iGate, TCS,

---

what is bridge tables in informatica

1 Answers   CTS,

---

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  

---