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
- 10136 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 |
What are the different options used to configure the sequential batches?
Can you access a repository created in previous version of Informatica?
Tell me about Propagate functions in informatica
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How is union transformation utilized?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
is it possible to index the data in cache of lkp transformation ?
how can we calculate fact table size?
how to run 2 workflows sequentially. plz respond what is the process?
Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Teradata 
