Answer / vaibhav bhandeo

Data modelling requires understanding of the requirements.
In general the design of data model can be a snowflake
(Highly normalized) or star schema (partial or not
normalized) which depends on whether you want optimal
utilization of space (Use star schema) or you want a
normalized data model easy to query and acess data (Use
snow flake).

What are ETL Tools?

0 Answers   Informatica,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

wt is the difference between truncate and delete in which situation u use delete and truncate in real time..

4 Answers   TCS,

---

What is the status code in stored procedure transformation?

0 Answers   Informatica,

---

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

---

Explain lookup transformation is active in informatica

0 Answers   Informatica,

---

What is session task and command task?

0 Answers  

---

what is workflow varible

1 Answers   HP,

---

What is meant by target load plan?

0 Answers  

---

What happens if we dont select data driven option?

2 Answers   Zensar,

---

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,

---

how do u move the code from development to production?

3 Answers  

---