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

Name the different lookup cache(s)?

1292

---

What is a router transformation?

1210

---

What is rank transformation in informatica

1230

---

what is unit testing?tell me proceedure

2272

---

explan ur project architecture?

2126

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3752

---

How can you differentiate between powercenter and power map?

1139

---

What is domain and gateway node?

1204

---

What are the different clients of powercenter?

1114

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2046

---

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

2297

---

How to load the data from people soft hrm to people soft erm using informatica?

1063

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

2346

---

If informatica has its scheduler why using third party scheduler?

1302

---

Could you explain what is enterprise data warehouse?

1223

---