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 does cheating measurement mean?

1003

---

Performance tuning( what you did in performance tuning)

1923

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1730

---

Explain the use of aggregator cache file?

1200

---

What is the sequence generator transformation in informatica?

1113

---

What is aggregator transformation in informatica?

904

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6061

---

What is confirmed fact in dataware housing?

6837

---

difference between repository database and repository service?

1093

---

What is joiner transformation?

960

---

What is meant by active and passive transformation?

1052

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2518

---

Explain direct and indirect flat file loading (source file type) - informatica

1275

---

What do think which one is the better joiner or look up?

1159

---

What is the need for an etl tool?

1020

---