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
Explian the Process of deployment groups in informatica
What is mapplet in informatica?
What are the different ways to implement parallel processing in informatica?
What is lookup transformation?
what is mean by complex business rule ?
How to handle decimal places while importing a flatfile into informatica?
I have a flat file, want to reverse the contents of the flat file
Explain load alternative records / rows into multiple targets - informatica
What are the reusable transformations?
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.
How can we update a record in the target table without using update strategy?
What are the tasks that source qualifier perform?
What is a mapplet/worklet in informatica?
design of staging area?
Plz can any one say me how to get the informatica certification materials and dumps