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 are the out put files that the informatica server creates during the session running?

2 Answers  

---

My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,

---

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,

---

How the informatica server sorts the string values in Rank transformation?

1 Answers   Informatica,

---

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?

8 Answers   BRAD, TCS,

---

what is runtime variable?

3 Answers   TCS,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

What does command task mean?

0 Answers  

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---