Answer Posted / suresh reddy

select eno,sal,sal+sal as totsal from ex GROUP BY sno,sal;
will give the output same as above

How to extract sap data using informatica?

983

---

Repository user profiles

1709

---

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1726

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

990

---

What are the mapping parameters and mapping variables?

1085

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

7865

---

what is unit testing?tell me proceedure

2163

---

Where are the source flat files kept before running the session?

1010

---

how tokens will generate?

2152

---

What is the use of code page?

1008

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1225

---

How can we improve session performance in aggregator transformation?

1038

---

Partition, what happens if the specified key range is shorter and longer

2432

---

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

948

---

Explain sessions. Explain how batches are used to combine executions?

952

---