How do you load unique records into one target table and duplicate records into a different target table?
No Answer is Posted For this Question
Be the First to Post Answer
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
in realtime which situations u can use unconnected lookup transformation
Enlist the various types of transformations.
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
What is a command that used to run a batch?
What are the types of caches in lookup?
what is parallel querying and what r hints.
my session have to run Monday to Saturday not run sunday how to sedule in informatica level?
1 Answers Infinite Computer Solutions,
difference between informatica 8.1.1 and 8.6
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.
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
what is the difference between copy object import objects using repositery manager which one is best