Answer Posted / ankit kansal

Hi All,
select sales,sum(q1),sum(q2),sum(q3),sum(q4)
from
select 'sales' as sales
,case when quarter='q1' then sales else 0 end case as q1
...q2
...q3
...q4
)temp group by sales;

http://deepinopensource.blogspot.in/

What is parallel processing in informatica?

1719

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2039

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2079

---

what are the Methods For Creating Reusable Transformations?

1185

---

What are the data movement modes in informatica?

1173

---

How to load the data from people soft hrm to people soft erm using informatica?

1026

---

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

1210

---

To import the flat file definition into the designer where should the flat file be placed?

1066

---

Explain sql transformation in script mode examples in informatica

1145

---

What is expression transformation?

1108

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2730

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2112

---

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

10692

---

What are the advantages of informatica?

1015

---

explain abt ur project architecture?

2200

---