Answer Posted / davan

Am not sure ..default join of look is left out join
so...use of joiner t/r with left outer join..we have to
look up.

Mention a few design and development best practices for informatica?

1000

---

What is a snowflake schema?

997

---

design of staging area?

2030

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1248

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1092

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

1506

---

What is flashback table ? Advance thanks

1942

---

To import the flat file definition into the designer where should the flat file be placed?

1061

---

What is the meaning of decode in informatica?

1122

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4164

---

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

---

generate date / time dimension in informatica

1128

---

What is powercenter on grid?

1179

---

where to store informatica rejected data?

1095

---

expain about the tune parameters?

2417

---