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 load the data with out a primary key of a table? what is target plan?

6 Answers   IBM,

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

---

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

---

WHAT IS THE DIFFERENCE BETWEEN .NET AND INFORMATICA?

1 Answers  

---

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow

4 Answers   Wipro,

---

Flat file heaving 1 lack records and I want to push 52000 records to the target?

7 Answers  

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

Diff b/w ShortCut and reusabel Object ?

4 Answers  

---

how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

---

What is the use of code page?

0 Answers  

---

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

---