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
Is it possible to revert a global repository to local one and why?
list out all the transformations which use cache?
can we override a native sql query within informatica? Where do we do it? How do we do it?
How do you load unique records into one target table and duplicate records into a different target table?
What is exclusive and normal mode for repository services?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Can informatica load heterogeneous targets from heterogeneous sources?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What is enterprise data warehousing?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Describe an informatica powercenter?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Could you explain what is enterprise data warehouse?
What is joiner transformation in informatica?
What is the need of an ETL tool?