Answer Posted / suresh

cant we write a subquery?

delete from table emp where exists (select * from emp where rownum=1 or 2 or 3);

count(empno) --> has to be stored in a variable port and delete the last three rows of the target table.

what is the difference between informatica6.1 and infomatica7.1

2204

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1047

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1574

---

How might one distinguish in the case of mapping is right or not without associating session?

1048

---

How big was your fact table

1756

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1456

---

what is degenerated dimension?

3891

---

What is fact table? Explain the different kinds of facts.

1027

---

What is a code page?

1126

---

server hot-ws270 is connect to Repository B. What does it mean?

2472

---

How you can differentiate between connected lookup and unconnected lookup?

1016

---

Is it possible to define a single node as a Gateway node as well as worker node?

1073

---

What is aggregate cache in aggregator transformation?

1081

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2038

---

wf dont have integration severances how you can run?

1895

---