Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

0 Answers  

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

What are the designer tools for creating tranformations?

1 Answers   Informatica,

---

How can you join two tables without any common column present in them?

1 Answers   TCS,

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---

which one is better performance wise joiner or look up

0 Answers   Informatica,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

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

4 Answers   CTS, Sonata,

---

I have a source as flat file and having data like ""TCS"MUMBAI" and i want output like TCS MUMBAI,the length of the data in the rows is variable.how can you fix it?

5 Answers   TCS,

---

What is enterprise data warehousing?

0 Answers  

---

why we are using level option in normalizer transformation

1 Answers   TCS, Wells Fargo,

---

How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  

---