Answer Posted / babu

Hi All,

ORACLE:
========
Below SQL query will give the exact result of what you
people are expecting.

SELECT rownum num,e.* From Emp e Where Rownum<=5
Union
SELECT * From
(SELECT Rownum Num,E.* From Emp E)
Where Num BETWEEN (SELECT round(Count(*)/2) From Emp)AND
(SELECT round(Count(*)/2) +1 From Emp)
Union

SELECT * From
(SELECT rownum num,e.* From emp e)
Where Num <=(SELECT count(*) From Emp)
And
Num>(SELECT count(*)-5 From Emp)

INFORMATICA:
============
please find the below mapping for your scenario.

SRC==>SQ==>(1)EXP==>AGG=====JNR===>RTR==T1,T2,T3
|| ||
(2)EXP==========

1> In first expression having the all columns coming from
the source and two extra columns(output ports)
I.one for sequence numbers.
II.second one is for constant value
2> In aggregatation transformation count the number of
records based(GROUP BY)on the dummy port.
3> In joiner transformation join the two flows(AGG and Exp
the join column is dummy port)

4> create 3 groups in Router transformation for 1St 5
records,Latst 5 records and Middle 5 records

GRP1::sno<=5
GRP2::sno<=cno+2 and sno>=cno-2 /*cno=count(*)*/
GRP3::sno<=cno and sno>cno-5

Cheers,
Babu rao

Explain me ETL project architecture in Detail?

2371

---

How many steps etl contains?

944

---

What are cubes and olap cubes?

985

---

Define Dynamic push down optmization?

2306

---

What is cube grouping?

1084

---

what is pmrep command?

2438

---

What is etl process? How many steps etl contains?

1034

---

When do we analyze the tables?

971

---

what is the use of server?

2198

---

What are the etl testing operations includes?

1111

---

What is staging area referring to?

1132

---

What is the difference between Data Warehousing and Data Mining?

1056

---

can be used COM component in Informatica ?

2060

---

What is a materialized view log?

999

---

What is data modeling and data mining?

976

---