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 is the advantage of informatica?

1062

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2109

---

Reusable transformation and shortcut differences

1837

---

scenario where i can use only concurrent execution of workflow.

3155

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2236

---

wf dont have integration severances how you can run?

1933

---

How many input parameters can exist in an unconnected lookup?

1537

---

What is a code page?

1167

---

what is the difference between informatica6.1 and infomatica7.1

2262

---

What are the types of schemas we have in data warehouse.

950

---

How to start a workflow using pmcmd command?

1235

---

what is diff b/t sorter t/r and agg have the option sorter property...

2169

---

Slowly changing dimensions, types and where will you use them

1700

---

What is domain in terms of informatica?

996

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2028

---