Interested to Buy Any Domain ? << Click Here >> for more details...
wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com
- 2 Answers
- 10264 Views
- I also Faced
- E-Mail Answers
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 |
How will you check the bottle necks in informatica? From where do you start checking?
How to generate sequence numbers without using the sequence generator transformation?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
Clarify the utilization of aggregator cache record?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000
What are connected or unconnected transformations?
Slowly changing dimensions, types and where will you use them
Explain the different kinds of facts.
What is the default join that source qualifier provides?
whats the option in informatica 7 version is outdated in informatica 8 version onwards.
in which situations do u go for sequence generator ?
Teradata 
