Answer / srinu

Fact tables will created by
(DBA people or senior architects) with PK-FK relation.
Mstly people will create PK-FK relation in facts After
loading the Data in Table).

Schemas : Mostly STAR Schema.

It will be useful for u ,,,,,,,,,,,

srinu.srinuvas@gmail.com

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

4 Answers   CTS, Sonata,

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

Diffrence between static and dynamic cache

2 Answers   HCL,

---

What is meant by active and passive transformation?

0 Answers  

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

---

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

2 Answers   ASM, TCS,

---

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,

---

What are data-driven sessions?

0 Answers  

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  

---