Answer Posted / hardeep

We can use below configurations to achieve desired output. We need 1 SQ, 1 SGen, 2 Rank and 2 Trgt Defn(same Trt). I think it will be cheaper.

Src-SQualifier-->
|
Rank1(Top 1st) -->Trgt1
--->
Rank2(Bottom 1st) -->Trgt2
|
SGen(NEXTVAL)-->

Why union transformation is an active transformation?

1049

---

What is the use of code page?

1097

---

list out all the transformations which use cache?

1187

---

Global and Local shortcuts. Advantages.

2035

---

Define sessions in informatica etl?

1038

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1130

---

Performance tuning( what you did in performance tuning)

1990

---

What could be the possible resons of locks by user?

1094

---

Where are the source flat files kept before running the session?

1083

---

What is an Integration service in Informatica?

1136

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

What are the mapping parameters and mapping variables?

1207

---

What is informatica?

1158

---

What is a passive transformation?

1105

---

Can u generate reports in Informatica?

1091

---