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 a passive transformation?

1147

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1950

---

Explain joiner transformation in informatica

1169

---

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2242

---

What is decode in static cache?

1254

---

What is an Integration service in Informatica?

1184

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1905

---

Explain the informatica workflow?

1119

---

can anyone explain me about retail domain project in informatica?

7996

---

What are ETL Tools?

1166

---

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

1186

---

can u any challenge your project?

2080

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

2148

---

whats the logic to load the lower level of granularity of data to fact table.

2308

---

explain abt ur project architecture?

2229

---