Answer Posted / anandini

Hi,
Pls send the dumps for all the 3 Informatica exams to me at
anandinib@hotmail.com
I am preparing for the certification.
Thanks in advance!!

how do u really know that paging to disk is happening while u are using a lookup transform?

2037

---

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2740

---

What is etl process. How many steps etl contains explain with example?

998

---

What is etl process?

976

---

what are the concerns of OLTP and DSS systems?

2504

---

What are the ETL Testing Operations?

1099

---

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1860

---

Explain the use lookup tables and Aggregate tables?

1023

---

what is data modeling?

1948

---

how do u identify the changed records in operational data?

2588

---

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

2587

---

Explain and compare etl & manual development?

972

---

What is data cleaning?

994

---

how to load the data to fact table?

2773

---

diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture

2603

---