Answer Posted / srikanth

select (select marks from sub where subject='maths') maths,
(select marks from sub where subject='science') science,
(select marks from sub where subject='social') social from
sub group by 1;

Explain sessions and how many types of sessions are there?

578

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1848

---

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 ?

1893

---

Explain why we use partitioning the session in informatica?

609

---

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

982

---

---

What is sorter transformation?

581

---

State the differences between sql override and lookup override?

620

---

How can repository reports be accessed without sql or other transformations?

723

---

What are the different transaction levels available in transaction control transformation?

673

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10276

---

Explain the different kinds of facts.

562

---

Explain in detail scd type 2 through mapping.

611

---

What is Index Caches size?

616

---

Explain direct and indirect flat file loading (source file type) - informatica

826

---

where to store informatica rejected data?

676

---