Difference between flat files and relational sources?

2 Answers  

---

Explain do we need an etl tool? When do we go for the tools in the market?

0 Answers  

---

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,

---

1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?

0 Answers  

---

what is session partitioning?

1 Answers  

---

---

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  

---

how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers  

---

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  

---

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1 Answers  

---

what is the use of server manager?

0 Answers  

---

when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?

0 Answers  

---

What are the three tiers in etl?

0 Answers  

---