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
- 10246 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 many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How can we handle two sessions in informatica?
What are the issues you have faced in your project? How did you overcome those issues?
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
How to update a particular record in target with out running whole workflow?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the use of transformation?
How does the server recognize the source and target databases. Elaborate on this.
Can we create a node as a gateway node and the same node can be assigned to a grid?
Teradata 
