Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com

Answers were Sorted based on User's Feedback



wt is inline view? when and why we Use ?mail to rayallarv@gmail.com..

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.

Is This Answer Correct ?    8 Yes 2 No

wt is inline view? when and why we Use ?mail to rayallarv@gmail.com..

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.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

What is the method of seperating unique and duplicate records in session level?

2 Answers   Emphasis, JBL, Wipro,


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,


how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,


tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  


What aer the out put files that the informatica server creates during the session running?

4 Answers  


where to store informatica rejected data?

0 Answers  


what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,


scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

1 Answers  


&#61656; Informatica Checkpoints

0 Answers   DELL,


How does the session recovery work.

1 Answers  


what is correlated query?

2 Answers   IBM,


why we need informatica

2 Answers   HCL,


Categories