Answer Posted / jaimeen shah

if you talk about in Informatica then in mapping use
Source Definition --> Source Qualifier (Default T/R) -->
Modified the SQ query to load the data that you have
required.
select empid, ename, sum(sal) as totalsal from test1
Group by years, ename, empid
Order by ename, empid
and connect the SQ ports to Target definition.
It gives you the result which you require.

What is a snowflake schema?

996

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2365

---

What is the commit type if you have a transaction control transformation in the mapping?

1030

---

What is the difference between a connected look up and unconnected lookup?

967

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2361

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1497

---

What is workflow manager?

1050

---

Why update strategy and union transformations are active?

1043

---

Can u generate reports in Informatica?

1089

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

2004

---

What are batches?

1101

---

What is informatica etl tool?

1000

---

What is mapping debugger?

1017

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6182

---

Tell me about MD5 functions in informatica

929

---