Using Informatica Visio to generate mappings.
I am getting error "Table Definition Not Found Exception Error" while importing the template.
Answer Posted / aa
Place the xml template in the MappingTemplate folder in ur C drive
u can refer more info below as well as Informatica KB
https://etltechsolutions.wordpress.com/2016/02/09/informatica-visio-table-definition-not-found-exception-error/
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Explian the Process of deployment groups in informatica
What is the need of etl tools?
What do you mean by filter transformation?
What are active transformations.
How do you load first and last records into target table?
How does the aggregator transformation handle null values?
What is xml source qualifier transformation in informatica?
what are the deliverables?in your project?
Why do you use Mapping Parameter and mapping variable?
Which means the first record should come as last record and last record should come as first record and load into the target file?
Why union transformation is an active transformation?
What is enterprise data warehousing?
What do you mean by worklet?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
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.