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



in a table it has 200 rows the query is select 150 from tablename.whats the output..

Answer / qlikstar

select 150 from tab
Ans:150
150
150
--
--
150(200 times)

Is This Answer Correct ?    7 Yes 0 No

in a table it has 200 rows the query is select 150 from tablename.whats the output..

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

Post New Answer

More Informatica Interview Questions

Do you find any difficulty while working with flat files as source and target?

0 Answers  


sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,


How to call stored Procedure from Workflow monitor in Informatica 7.1 version?

1 Answers   Accenture,


What you know about transaction control transformation?

0 Answers  


Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  






What do you understand by term role-playing dimension?

0 Answers  


what is the function of 'F10' informatica ?

4 Answers   IBM,


What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,


Performance tuning( what you did in performance tuning)

0 Answers   Infosys,


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  


Can we use Union Transformation for Heterogeneous sources? i.e; 3 sources, 1 from Oracle, 2nd from Informix, 3rd from Sql Server with same metadata?

3 Answers   TCS,


What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

0 Answers   TCS,


Categories