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
8988 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

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers IBM,

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

0 Answers Cognizant, IBM,

What are conformed dimensions?

1 Answers

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers Wipro,

What is target update override

2 Answers CTS,

I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance

6 Answers IBM, TCS,

Enlist the various types of transformations.

0 Answers

Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer

3 Answers TCS,

wat are deployement groups in informatica, how it will be used for developers

0 Answers

What is IQD file?

1 Answers

For more Informatica Interview Questions Click Here