wt is inline view? when and why we Use ?mail to
rayallarv@gmail.com
Answer Posted / mehul thakur
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 |
Post New Answer View All Answers
What are the conditions needed to improve the performance of informatica aggregator transformation?
What are the static cache and dynamic cache in informatica?
Enlist the differences between database and data warehouse.
During the running session, output files are created by informatica server. Enlist few of them.
What is expression transformation?
What are connected or unconnected transformations?
State the limitations where we cannot use joiner in the mapping pipeline?
Define mapplet?
What are mapplets?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
my source is junk data how will u remove that junk data by using unix please any one replay me
Explain constraint based loading in informatica
What is complex mapping?
tell me 5 session failure in real time how can you solve that in your project?
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?