in a table it has 200 rows the query is select 150 from
tablename.whats the output
Answers were Sorted based on User's Feedback
Answer / 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 |
What do you understand by term role-playing dimension?
what is mean by complex business rule ?
I have 1200 records how can u send it in aggregator with good performance issues?
What is the Hierarchy of DWH?
What is persistent lookup cache?
Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??
how much memory (size) occupied by a session at runtime
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 a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
What is aggregate awareness?
what is the significance of newlookup port in dynamic look up
what is datamart