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

What is the sequence generator transformation in informatica?

0 Answers  

---

Explain the aggregator transformation?

0 Answers  

---

How to load the source table into flat file target(with columns) in informatica?

4 Answers   Accenture,

---

What are the Differences between static cache and dynamic cache?

1 Answers  

---

What are the issues you have faced in your project? How did you overcome those issues?

0 Answers   CTS, FEEE, TCS,

---

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

2 Answers   Puma,

---

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

---

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

---

how to get the only updated records in the target

2 Answers  

---

get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,

---

what is the difference between stop and abort

2 Answers  

---

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,

---