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

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

Question Posted / guest

2 Answers
9126 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Why do we use DSS database for OLAP tools?

2 Answers

What are the reusable transforamtions?

2 Answers

Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers

Explain the different kinds of facts.

0 Answers

How to recover the standalone session?

2 Answers

i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .

6 Answers Emphasis,

What aer the out put files that the informatica server creates during the session running?

4 Answers

I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers

Why we use stored procedure transformation?

4 Answers

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers Informatica,

Which one is better performance wise connected/un-connected lkp?why?

2 Answers HCL, TCS,

For more Informatica Interview Questions Click Here