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.

can we generate reports in informatica ? How?

3 Answers  

---

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

---

What is a predefined event?

0 Answers  

---

Can anyone please distinguish what is Inner join and Outer join

2 Answers   Wipro,

---

What is confirmed dimension?

3 Answers  

---

How to create a non-reusable instance of reusable transformations?

0 Answers   Informatica,

---

What are Rapid changing dimensions?

1 Answers  

---

what is INFORMATICA TESTING process

0 Answers  

---

Can you create a flatfile target

3 Answers   ABC,

---

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

---

what is constraint based loading

2 Answers   IBM,

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers   IBM,

---