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;

Mention few power centre client applications with their basic purpose?

890

---

How to handle decimal places while importing a flatfile into informatica?

1127

---

What is option by which we can run all the sessions in a batch simultaneously?

1077

---

design of staging area?

1961

---

If informatica has its scheduler why using third party scheduler?

1192

---

Explain transaction control transformation in informatica

1210

---

What is a passive transformation?

1036

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2075

---

what is INFORMATICA TESTING process

2224

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2178

---

where to store informatica rejected data?

1045

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3648

---

what is $$$$?

2095

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1873

---

what are the deliverables?in your project?

2084

---