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

how to improve performence by using sorted input in aggrigator t/r.

2 Answers  


What are the advantages of informatica?

0 Answers  


What is the reusable transformation?

0 Answers  


What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance

3 Answers  


can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

1 Answers   Puma,


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  


What is Data Caches size?

0 Answers   Informatica,


What is a filter transformation and why it is an active one?

0 Answers  


How can we use batches?

0 Answers  


i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,


Write the prerequisite tasks to achieve the session partition?

0 Answers  


While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,


Categories