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
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 |
what is a junk dimension ?
14 Answers Atos Origin, Cognizant, HS, NIIT, TCS,
Different types of Power center errors?
Difference Between ETL & ELT?
What are the reusable transformations?
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
What is the function of union transformation?
How can u work with remote database in informatica?did you work directly by using remote connections?
Can anyone tell me the new features in Informatica 9 Version?
How can we integrate different flat file data in a single mapping and with in a single execution
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
Which transformation should u need while using the cobol sources as source defintions?
i have source in oracle 10g,oracle 8i how will u take the data from two sources