Answer / kalpana

Inline view is a construct in oracle.Inline views allow us
to do things in a single query that might otherwise require
multiple sql statements.

A common use for inline views is to simplify complex
queries by removing join operations and condensing several
separate queries into a single query.

Answer / mehul thakur

The concept of using subquery in the FROM clause of SELECT statement is called INLINE VIEW.
A subquery in the from clause of SELECT statement defines a data source from that particular statement.

What are the ETL tools available in DWH?

6 Answers   Mphasis,

---

Do joiner transformation use cache? If so describe?

2 Answers   Patni,

---

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail

2 Answers   Amdocs,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

Define Update Override?

1 Answers  

---

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

0 Answers   Keane India Ltd,

---

What is a rank transform?

0 Answers  

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

Whats there in global repository

0 Answers  

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---