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 |
how to load rows into fact table in data warehouse
can we override a native sql query within informatica? Where do we do it?
without using emailtask how will send a mail from informatica?
write a sql query following table some duplicate present 1 1 2 2 3 3 4 5 i want the output unique one column duplicate another column following format like unique duplicate 1 1 2 2 3 3 4 5
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
How Union Transformation is an Active Trans?
why union is active transformation?
IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP TRANSFORMATION ?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What are the performance considerations when working with aggregator transformation?
What is diff between connected and unconnected lookup?
5 Answers BirlaSoft, Blue Star Infotech,