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

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,


what is difference between mapping and mapplet ?

2 Answers   TCS,


If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


How many repositories can be created in informatica?

1 Answers  


How to prepared lld.can any one tell me detailed explanetion.

0 Answers   Bank Of America,


How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!

2 Answers  


Mapplets can you use an active transformation in a mapplet,

1 Answers  


How do you change a non-reusable transformation to reusable transformation?

0 Answers  


How we can confirm all mappings in the repository simultaneously?

1 Answers  


What is the way to execute pl/sql script using informatica mapping?

0 Answers  


which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..

7 Answers   TCS,


Categories