wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com
Answers were Sorted based on User's Feedback
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 |
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 |
tell me the informatica architecture
How can you generate reports in informatica?
How do you recover rows from a failed session
What do you understand by term role-playing dimension?
list out all the transformations which use cache?
Difference Between ETL & ELT?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
what is the diff b/w union and joiner and lookup?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is difference between maplet and reusable transformation?
What is intricate mapping?
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?