in a table it has 200 rows the query is select 150 from
tablename.whats the output
Answer Posted / babu
Hi all,
it is very simple.
if you give any number in the select list it will displays the
that number(how many records table havie that number of times)
Ex: select 200 from tab
Ans:200
200
200
--
--
200(200 times)
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Explain the difference between a data warehouse and a data mart?
How do you update the records with or without using update strategy?
In informatics server which files are created during the session rums?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
what is the size of u r source(like file or table)?
generate date / time dimension in informatica
What is the advantage of informatica?
How do you handle two sessions in Informatica
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
Define filter transformation?
draw informatica architecture 8.6 ?
What is the difference between stop and abort in informatica
What is the difference between Active and Passive transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?