Answer / guest

we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

How do we call shell scripts from informatica?

0 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

0 Answers   SeeInfoBiz, TCS,

---

Is it possible to revert a global repository to local one and why?

0 Answers  

---

---

i have 2 mapings for this 2 mapings i want use only one lookupt/r how?

3 Answers   Wipro,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

Informatica and datawarehousing courses in Pune?

2 Answers  

---

What is primary and backup node?

0 Answers  

---

Which transformation is needed while using the Cobol sources as source definitions?

0 Answers   Informatica,

---

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

---

What is confirmed dimension with scenario

1 Answers   HCL,

---