What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / chandrasekar
Hi Suraj,
Your SQL query is not working? so please try in oracle and
once again load to site.
Thanks for ur help.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain direct and indirect flat file loading (source file type) - informatica
What is a pre-defined event and user-defined event?
Explain sessions. Explain how batches are used to combine executions?
What is data transformation manager process?
can anyone explain me about retail domain project in informatica?
Mention some types of transformation?
What is the function of aggregator transformation?
Differentiate between joiner and lookup transformation?
How can you validate all mappings in the repository simultaneously?
What is the different lookup cache(s)?
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 are active transformations.
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
On which transformations you created partitions in your project?
The question was on time stamp. what is the difference between HH and HH24 when to use when.