Answer Posted / pandu

ALTER SESSION SET NLS_TERRITORY = 'INDIA';

SELECT TO_DATE(
'January 15, 1989, 11:00 A.M.',
'Month dd, YYYY, HH:MI A.M.',
'NLS_DATE_LANGUAGE = INDIA')
FROM DUAL;

scenario where i can use only concurrent execution of workflow.

3140

---

Explain what are the different versions of informatica?

1082

---

What are the components of Informatica? And what is the purpose of each?

1030

---

Which are the different editions of informatica powercenter that are available?

1022

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1618

---

Can we create two repositories on same database instance in oracle?

1074

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1561

---

How are indexes created after completing the load process?

1622

---

What is the reusable transformation?

1034

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1679

---

What are the tuning techniques you applied during your last project

2013

---

What is Index Caches size?

1094

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1046

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

2285

---

What is the function of union transformation?

1112

---