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 |
What is the method of seperating unique and duplicate records in session level?
2 Answers Emphasis, JBL, Wipro,
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how do u fnd the duplicate rows and how to delete the duplicate rows?
tell me 7.x and 8.x diferrencess(but not transformations)
What aer the out put files that the informatica server creates during the session running?
where to store informatica rejected data?
what is the main advantage of unconnected lookup
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
 Informatica Checkpoints
How does the session recovery work.
what is correlated query?
why we need informatica