Answer Posted / babu

Hi


Mapping:
========

Src==>SQ==>Exp==>Rtr(GRP1,GRP2,GRP3)==>T1,T2,T3
||
Seq

EXp:column1,Nexval(come from Seq Trans)

Rtr: have 3 groups
GRP1:MOD(Nextval,3)=1 ===>T1
GRP2:MOD(Nextval,3)=2 ===>T2
GRP3:MOD(Nextval,3)=0 ===>T3

What are connected or unconnected transformations?

1129

---

What is enterprise data warehousing?

1058

---

How to configure mapping in informatica?

1180

---

What is a stored procedure transformation?

1064

---

Explain pmcmd command usage in informatica

1141

---

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.

2208

---

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

1137

---

What is the session task and command task?

1069

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1217

---

Which files are created during the session rums by informatics server?

1192

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1698

---

lookup transformation with screenshots

4014

---

What is joiner change?

1156

---

How can we improve session performance in aggregator transformation?

1126

---

what is the hint? how to use it to reduce the query processing in program?

7854

---