Answer / kishor baindoor

a) source can be Flat files , Cobol Files , Oracle table etc
b) Fact table will be having main data where as dimention
ttable describes attributes of fact table. primary keys for
ddimentional table will foreign key of fact table. go
through dimentional modelling.

Do you have knowledge in ralph kimball methodology

1 Answers  

---

can session assigned multiple mappings or not?

2 Answers   Zensar,

---

what is the logic will you implement to laod the data in to one factv from 'n' number of dimension?

3 Answers  

---

In a scenario I have col1, col2, col3, under that 1,x,y, and 2,a,b and I want in this form col1, col2 and 1,x and 1,y and 2,a and 2,b, what is the procedure?

5 Answers  

---

hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..

1 Answers   Wipro,

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

What are the mapings that we use for slowly changing dimension table?

2 Answers  

---

what is fact and what types of fact tables is there

4 Answers   Cap Gemini,

---

1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach

4 Answers   Virtusa,

---

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,

0 Answers   HCL,

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---