What is a unit Testing?
Answer / rkumar.etl
Unit testing in Informatica performed using ...
1)src qualifier query if providing us the final result
..with only calculating logic in between than ...test the
count results in sql navigator.
2)column to column mapping to make sure the result passing
to columns are correct.
3)data type mismatch or matched.
Is This Answer Correct ? | 5 Yes | 0 No |
State the differences between sql override and lookup override?
How many input parameters can exist in an unconnected lookup?
When do you use sql override in a lookup transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Please let me know how to make encryption and decryption with example?
What is the term PIPELINE in informatica ?
in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna
how we load the data from source to staging area
What is resilience time?
How we can create indexes after completing the loan process?
How to load the data from a flat file into the target where the source flat file name changes daily?
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.