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 do you mean by channel change?

1051

---

What is the procedure for creating independent data marts from informatica 7.1?

1067

---

Explain what is informatica metadata and where is it stored?

1051

---

have u done any performance tuning? how u ll do?

2299

---

How many numbers of sessions can one group in batches?

1064

---

What are the types of caches in lookup?

1052

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1688

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1150

---

What is mapplet in informatica?

1060

---

Explain what are the different types of transformation available in informatica.

1152

---

Define the various join types of joiner transformation?

988

---

Explain the different dimensions.

971

---

how to load dimension table and fact table. plz tell me the steps.

2094

---

How is union transformation utilized?

1013

---

What is flashback table ? Advance thanks

1942

---