Answer / rakesh

Data normalization is a process in which data attributes
within a data model are organized to increase the cohesion
of entity types. In other words, the goal of data
normalization is to reduce and even eliminate data
redundancy, an important consideration for application
developers because it is incredibly difficult to stores
objects in a relational database that maintains the same
information in several places.

Level
Rule

First normal form (1NF)
An entity type is in 1NF when it contains no repeating
groups of data.

Second normal form (2NF)
An entity type is in 2NF when it is in 1NF and when all of
its non-key attributes are fully dependent on its primary
key.

Third normal form (3NF)
An entity type is in 3NF when it is in 2NF and when all of
its attributes are directly dependent on the primary key.

What is a grid in Informatica?

0 Answers  

---

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  

---

what are the real time problems generally come up while doing or running mapping or any transformation?

2 Answers  

---

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

4 Answers   CTS, Sonata,

---

What is the difference between OLTP and ODS?

4 Answers  

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

What is the difference between informatics 7x and 8x and what is latest version?

0 Answers  

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---