Answer Posted / kamleshmishra291

SELECT * FROM TABLE_NAME PIVOT( MAX(SALES) FOR REGION IN (1,2));

Difference between Data and Index Caches?

1124

---

what are 3 tech challenges/ common issues you face?

2326

---

How to join three sources using joiner? Explain though mapping flow.

1126

---

Explain the tuning lookup transformation - informatica

977

---

How is union transformation utilized?

995

---

What is dimensional table? Explain the different dimensions.

1155

---

can we override a native sql query within informatica? How do we do it?

1103

---

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1063

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1836

---

While migrating the data from one environment to another environment how would you manage the connections?

1073

---

What are the types of caches in lookup?

1034

---

without table how to come first record only in oracle?

2233

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4128

---

What is a stored procedure transformation?

1034

---

Define Pmrep command?

1029

---