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

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1914

---

What is informatica?

1158

---

What are the designer tools for creating transformations?

1119

---

What is an Integration service in Informatica?

1136

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2136

---

Explain the aggregator transformation?

1169

---

what is song in infrmatica...?

2238

---

Differentiate between Load Manager and DTM?

2160

---

can anyone suggest best free Talend data integration training online

1694

---

Define sessions in informatica etl?

1038

---

what is the Default Source Option For Update Strategy Transformation?

1242

---

How to join three sources using joiner?

1118

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2361

---

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7188

---

What are the types of schemas we have in data warehouse and what are the difference between them?

944

---