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

Explain the difference between mapping parameter and mapping variable?

1036

---

how to load rows into fact table in data warehouse

1188

---

What is the Process to creating lookup transformation in informatica

1043

---

What is a snowflake schema?

994

---

What do you mean by enterprise data warehousing?

1063

---

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1038

---

Why do we need informatica?

990

---

How can we store previous session logs?

1078

---

What's the layout of parameter file (what does a parameter file contain?)?

2385

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1106

---

what is the size of u r source(like file or table)?

2272

---

What are roles and groups and benefits of using them?

1057

---

Can we create two repositories on same database instance in oracle?

1089

---

How can we create index after completion of load process?

1125

---

How to use pmcmd utility command?

1032

---