Answer / sbvp

router filter
1.mutlipule conditions here 1.single condition here
2.send to multiple targets 2.single target
3.it captures the rejected records 3.it doesnot capture
in default output rejected records
group.
4.this is active t/r 4. this is also activet/r

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

---

What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,

---

(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance

1 Answers  

---

how to load rows into fact table in data warehouse

0 Answers   Informatica,

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers   TCS,

---

Why do you use Mapping Parameter and mapping variable?

0 Answers  

---

In dimension and fact table? which one holds big data?

2 Answers  

---

Performance wise which is better joiner or look up ? Give me with example?

1 Answers   CGI,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

when we go for unconnected lookup transformation? and why?

5 Answers   Accenture,

---

what is diff between grep and find

3 Answers   IBM, iFlex,

---