Answer Posted / sakthi

i think we can write sql query in first source qualfier and and select another source qualifier and write sql over ride query
1)select * from employees where rownum <= ( select count(*)/2 from employees);

2)select * from employees minus (select * from employees where rownum <= ( select count(*)/2 from employees));

How to extract the informatica rejected data?

1259

---

Explain the different dimensions.

1009

---

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

1115

---

According to his methodology what all you need before you build a datawarehouse

1802

---

What is xml source qualifier transformation in informatica?

1278

---

How do you use reject loader.

2651

---

What are the new features of Power Center 5.0?

1849

---

Slowly changing dimensions, types and where will you use them

1773

---

Explain the features of connected and unconnected lookup.

976

---

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

1133

---

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

2293

---

What are the restrictions of union transformation?

1088

---

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?

1990

---

What is dynamic cache?

1086

---

What is source qualifier transformation in informatica?

1066

---