in a table it has 200 rows the query is select 150 from
tablename.whats the output
Answer Posted / 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 View All Answers
what is the size of your data warehousing?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
difference between informatica 8.1.1 and 8.6
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the use of target designer?
my source is junk data how will u remove that junk data by using unix please any one replay me
Differentiate between reusable transformation and mapplet.
How can informatica be used for an organization?
How do you load only null records into target?
hi real timers . iam waiting for ur reply regarding ETL TESTING
Enlist the various types of transformations.
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
what is the size ur source like(file system or database)? how many record daily come u r banking project?