Answer / sujana

it updates the row in the cache r leaves it unchanged

Answer / chandra

This lookup property is recomended only for the mapping
where soures has duplicate records

how to remove staging area

1 Answers  

---

can we see default group,when we use router?if yes how?

2 Answers   L&T,

---

What is a dimensional model?

0 Answers  

---

i have two tables,table 1 having 2 columns and 3 rows,table2 having 3 columns and 2 rows.what is the output if i do left outerjoin,full outer join,right outer join?

2 Answers   IBM, Polaris,

---

While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?

4 Answers  

---

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?

0 Answers   Bosch,

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

1 Answers   TCS,

---

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

---

expain about the tune parameters?

0 Answers   TCS,

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---