1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

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 can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,

When you move from devel to prod how will you retain a variable

1 Answers  

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers  

What is the difference between a table and the materialized view?

2 Answers  

Can you create a flatfile target

3 Answers   ABC,

what is a time dimension? give an example?

2 Answers   IBM,

During the running session, output files are created by informatica server. Enlist few of them.

1 Answers  

what is correlated query?

2 Answers   IBM,

What is the difference b/w natural key and surrogate key

1 Answers  

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.

1 Answers  

Enlist the various types of transformations.

1 Answers  

For more Informatica Interview Questions Click Here
Categories