Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / deepthi
etl's r of 2 types.code based n gui based.in code based etl
we have some limitations.inorder 2 over come those
limitations we use gui based etl ninformatica is 1 among
the gui.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is workflow? What are the components of the workflow manager?
What are the steps involved in the migration from older version to newer version of Informatica Server?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How many input parameters can exist in an unconnected lookup?
Reusable transformation and shortcut differences
What is an expression transformation in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How many ways are there to do 'remove duplicate records in informatica'?
How to update a particular record in target with out running whole workflow?
What is persistent lookup cache?
What does refresh system mean, and what are its distinctive choice?
What is the need of etl tools?
Enlist the differences between database and data warehouse.
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.
