Answer Posted / sp hari

select * from emp where rowid=(select
decode(mod(rownum,2),0,null,rowid) from emp)

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2120

---

Explain the different kinds of facts.

1020

---

can u give example for factless fact table

6769

---

Explain load alternative records / rows into multiple targets - informatica

1201

---

What is meant by active and passive transformation?

1189

---

What is rank transformation?

1033

---

Is stop and abort are same in informatica?

1039

---

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 many input parameters can exist in an unconnected lookup?

1598

---

What is meant by pre and post session shell command?

1198

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2085

---

How big was your fact table

1855

---

What are junk dimensions?

1111

---

What is event and what are the tasks related to it?

1199

---

Partition, what happens if the specified key range is shorter and longer

2550

---