Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is a repository? And how to add it in an informatica client?

0 Answers   Informatica,

How does the aggregator transformation handle null values?

0 Answers  

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

What are the types of presistent cache in look up tr.

0 Answers   IBM,

How do you take care of security using a repository manager

2 Answers  

how to load dimension table and fact table. plz tell me the steps.

0 Answers   Cognizant, IBM,

How can we use mapping variables in informatica?

0 Answers  

What is primary and backup node?

0 Answers  

Explain the types of transformations?

0 Answers  

i have source in oracle 10g,oracle 8i how will u take the data from two sources

2 Answers   TCS,

How can you complete unrcoverable sessions?

1 Answers  

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

For more Informatica Interview Questions Click Here
Categories