How many ways are there to create ports?

0 Answers   Informatica,

---

What are junk dimensions?

0 Answers  

---

what are the transformations that are used in data cleansing ? and how data cleansing takes place ?

3 Answers  

---

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

---

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

What are the tasks that can be performed using sq?

0 Answers  

---