wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com
- 2 Answers
- 9288 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 can i send first half of the records to one target and Remaining to other target?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
Write the unconnected lookup syntax?
Why you use repository connectivity?
What is olap (on-line analytical processing?
Can we use parameters of parameter file in presession command
how can u connect client to ur informatica sever iff server is located at different place( not local to the client)
what is mean by grouping of condition column in lookup transformation?
what is shortcut in informatica? difference between shortcut,reusable object?
What is domain in terms of informatica?
Design a mapping to calculate department wise sum of salaries and load it in single target? Source Target Deptno Salary Deptno Salary 10 100 10 600 10 200 10 600 10 300 10 600 20 200 20 800 20 300 20 800 20 300 20 800 30 400 20 1500 30 500 30 1500 30 600 30 1500
Define the various join types of joiner transformation?
Teradata 
