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

0 Answers   L&T,

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  

---

Identifying the bottlenecks in various components of Informatica and resolving them.

2 Answers  

---

Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?

1 Answers  

---

can be used COM component in Informatica ?

0 Answers  

---

Explain about hash partitioning?

0 Answers  

---

what is meant by drill through?(Mascot)

1 Answers  

---

Explain about etl data integration software?

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,

---

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

0 Answers  

---

what is data modeling?

0 Answers  

---