Answer Posted / gvk

Here

SOURCE------>SQ--->AGG---> SEQ\ /T1
----->JOINER----->ROUTER----
SOURCE------>SQ--->EXP---> \T2


THIS IS THE PROCESS
HERE AGG--->TWO PORTS 1)NEW PORT 2)COUNT PURPOSE
EXP---->1)NEW PORT ONLY
JOINER-->COMPARE TO THE (AGG & EXP) NEW PORTS AND
APPLY THE FULL JOIN
ROUTER--->TWO CONDITIONS

Briefly explain the aggregator transformation?

985

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2436

---

How do you load only null records into target? Explain through mapping flow.

1999

---

Differences between version 7.x and 8.x.

1882

---

EXL informatica Questions

1360

---

How to generate sequence numbers without using the sequence generator transformation?

1182

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4095

---

What is the need of an ETL tool?

1072

---

is it possible to index the data in cache of lkp transformation ?

2018

---

Is it possible to revert a global repository to local one and why?

1064

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1071

---

What are active and passive transformations?

1072

---

Is there any way to read the ms excel datas directly into informatica?

1013

---

Enlist the advantages of informatica.

1047

---

How to load data in informatica ?

990

---