Answer Posted / gireesh

Normalization is a process in database design which groups
data into various tables which are then crosslinked by a
particular field. In a properly normalized database, there
will be only one field in one table for a particular piece
of data, eliminating possibility for conflicts. Breaking the
database up into numerous smaller tables, and eliminating
redundancies, eases management and enhances efficiency.

what are Lookup caches options? Including persistent caches.

1536

---

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2518

---

What is tracing level and what are the types?

620

---

What is the difference between Data Warehousing and Data Mining?

644

---

What is lookup table in etl testing?

821

---

---

What are the different etl testing categories as per their function?

629

---

What are snapshots?

638

---

Difference between flat files and relational sources?

1850

---

Compare etl & elt?

660

---

how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2177

---

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1709

---

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3401

---

flat filevalidation in informatica

1827

---

What is meant by incremental load?

681

---

When do we analyze the tables? How do we do it?

621

---