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 |
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
what is difference between mapping and mapplet ?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How many repositories can be created in informatica?
How to prepared lld.can any one tell me detailed explanetion.
How or for what purpose look up transformation would be useful in Sales or Banking Project? Please reply!
Mapplets can you use an active transformation in a mapplet,
How do you change a non-reusable transformation to reusable transformation?
How we can confirm all mappings in the repository simultaneously?
What is the way to execute pl/sql script using informatica mapping?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..