Answer / srinu

Look up Transformatoin only,
its going to maintain existing data also in cach memory

Answer / subhransu,bangalore

costly means consuming more memory.which transformation have cache memory.
example:lookup TR
sorter TR
aggregator TR
rank TR
joiner TR

Answer / soujanya

costliest means occupying more memory.
filter
sorter
aggregator
rank
lookup
the transformations having cache memory

Why touse stored procedure in ETL Application?

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 work of PUSH DOWN option

2 Answers   Wipro,

---

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 Answers  

---

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  

---

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

---

Explain the different dimensions.

0 Answers  

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

---

What are the differences between source qualifier and joiner transformation?

0 Answers  

---