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 system requirement(SR) & business requirement(BR)?

2 Answers   Ness Technologies,

---

On which transformations you created partitions in your project?

0 Answers   Cap Gemini,

---

What is option by which we can run all the sessions in a batch simultaneously?

0 Answers   Informatica,

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it

1 Answers  

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

I have 2records in target table and this record is deleted in source. Now if I run mapping twice how many records do target will have,  source having 10records. Same with incrementally.  Please  answer me ASAP. 

1 Answers   Cipla, Quintiles,

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

How do you change a non-reusable transformation to reusable transformation?

0 Answers  

---