Answer / swetha

Partitioning achieves the session performance by reducing
the time period of reading the source and loading the data
into target.

Answer / honey

The PowerCenter® Partitioning Option increases the
performance of PowerCenter through
parallel data processing, and it has been instrumental in
establishing PowerCenter’s industry
performance leadership. This option provides a thread-based
architecture and automatic data
partitioning that optimizes parallel processing on
multiprocessor and grid-based hardware
environments

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

9 Answers   BirlaSoft, Genpact, L&T, Syntel,

---

What are the prerequisite tasks to achieve the session partition?

0 Answers  

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

Explain the etl program with few examples.

0 Answers  

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

How can we use mapping variables in informatica? Where do we use them?

0 Answers  

---

What is synonym?

2 Answers   Patni,

---

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,

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

Can we get 1st record through Informatica(without sequence number).

0 Answers  

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

0 Answers  

---

In a concurrent batch if a session fails, can you start again from that session

1 Answers  

---