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
- 10347 Views
- I also Faced
- E-Mail Answers
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
Mention few power centre client applications with their basic purpose?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Define update strategy?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is dynamic cache?
Sequence generator, when you move from develoment to production how will you reset
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is meant by incremental aggregation?
Explain sql transformation in script mode examples in informatica
waht type of interface is used for testing the data in informatica
What are the components of Informatica? And what is the purpose of each?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
