Answer Posted / venkateshmalneni

FIRS PIPELINE
BY using sequence generator t/r generate sequence
numbers(sno)
in rank t/r,from sq connect all the ports to the rank
t/r,rank by sno,select top 3 ranks
SECOND PIPELINE
connect the nextval port from sequence generator to sorter
t/r
from sq connect all the ports to the sorter t/r,connect all
the ports to the filter t/r.in filter t/r write a condition
sno>3.

connect the o/p of the two pipelines by using UNION T/R
connect the o/p of the Union t/r to aggrigator t/r group by
sno.create an o/p port with name count_sno to
count(sno),connect the o/p from aggrigator t/r to the filter
t/r write the condition count_sno=1.
connect the o/p from filter to trg
THE DATA FLOW DIAGRAM IS LIKE THIS
sequence generator
| |
| \|/
src--->sq--->rank------>union--->aggrigator---->filter->trg
| | /
\|/ \|/ /
sortet----->filter/

If am wrong please let me know

What are the features of complex mapping?

1096

---

How to improve the performance of a session using sorter transformation?

1092

---

Why union transformation is an active transformation?

993

---

What are the differences between a connected lookup and unconnected lookup?

1015

---

Which version configuration tool used in ur project?

3181

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2677

---

What are the new features of Power Center 5.0?

1699

---

What is the meaning of decode in informatica?

1073

---

What is the difference between a connected look up and unconnected lookup?

910

---

How many ways a relational source definition can be updated and what are they?

952

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

915

---

How do you load only null records into target? Explain through mapping flow.

1956

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5561

---

Clarify the aggregator change?

970

---

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

2179

---