Answer / gangam rajesh

Bridge table is a association table between two multivalued
dimension tables i.e. which have many to many relation.
Actually database doesn't support m to m relationship so
by using this bridge table we convert the m to m relation
ship into two 1 to many relationships.Bridge table contains
primarykeys of both dimensional tables as a compositekey

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

What is the meaning of decode in informatica?

0 Answers  

---

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

1 Answers   Accenture,

---

How to recover the standalone session?

2 Answers  

---

How informatica recognizes mapping?

2 Answers   CTS,

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

can we use mapplet as starting n ending object in mapping

2 Answers   TCS,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

how to join two flat file if they have diff. structure?how to join one relational and one flat file?

4 Answers   Wipro,

---