Answer Posted / chemistrya2z

select * from <tbl> where rownum<2;

How to update or delete the rows in a target, which do not have key fields?

1224

---

Explain Dataware house architecture .how data flow from intial to end?

2650

---

What are the different ways to implement parallel processing in informatica?

1482

---

which one is better performance wise joiner or look up

1151

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2108

---

What are the different clients of powercenter?

1117

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847

---

What is powercenter on grid?

1228

---

How do we call shell scripts from informatica?

1191

---

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?

6580

---

How to do unit testing in informatica? How to load data in informatica ?

1187

---

Separate from a database, an information bazaar, and an information stockroom?

1131

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1206

---

What is a difference between complete, stop and abort?

1125

---

What is Data Caches size?

1130

---