how to get the first row without using rank t/r?
Answer Posted / venkatgiri
select * from Table_name limit 1
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is informatica?
Enlist few areas or real-time situations where informatica is required.
Difference between Data and Index Caches?
What is the difference between a connected look up and unconnected lookup?
how we can load rejected record's at run time?(not through bad files)
What are the different clients of powercenter?
What is the difference between stop and abort in informatica
How union transformation is used?
can you please explain me pre session and post session options?
What are different types of transformations available in informatica?
Explain the scenario which compels informatica server to reject files?
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 meant by query override?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Dimension Object created in Oracle can be imported in Designer Cubes contain measures