Answer / dr.journalist

Fact table basically consists of Foreign keys which are
taken from the primary keys of all dimension as well as
facts.
So, for this reason take all the dimensions as Unconnected
lookups and try to take the foreign keys and at the same
time try to use the avaialble sources and make all possible
facts with the necessary transformations.

what is lookupoverriding?

1 Answers  

---

State the differences between sql override and lookup override?

0 Answers  

---

Make a note of the quantity vaults made in informatica?

0 Answers  

---

what is normalizer transformation?

4 Answers   Wipro,

---

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,

---

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

2 Answers   Infosys, TCS,

---

Whatis the difference between View and Materialized View ?

11 Answers   Satyam, Syntel,

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

What is a taget load order?

2 Answers   IBM,

---

i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  

---

differences between service based and product based?

0 Answers   Satyam,

---

Explain pushdown optimization $pushdownconfig parameter - informatica

0 Answers   Informatica,

---