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

How to load data into 3 target tables which are in different schema but with the same name and same relational connection at infromatica level ? How to differentiate while loading ? and how to load ?

2 Answers   IBM,


what type of problem you faced insales project or insurance project

1 Answers   Sony,


How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,


How to jion 2 tables, without using any condition?

11 Answers   Amazon,


What is degenerated dimention table?

7 Answers   Patni,






What is the exact difference b/w IN and EXIST in Oracle..?

4 Answers   Wipro,


What is the difference between warehouse key and surrogate key?

1 Answers   Accenture,


How the facts will be loaded? explain

2 Answers   HCL,


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc

3 Answers   HP,


What are the new features of the server manager in the informatica 5.0?

1 Answers  


How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,


Categories