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.
No Answer is Posted For this Question
Be the First to Post Answer
Difference between STOP & ABORT in Informatica.
3 Answers Accenture, Wells Fargo,
What are the types of schemas we have in data warehouse and what are the difference between them?
what is distinct
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
tell me about your project functionality
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
What is the fact table?
what is the command to get the list of files in a directory in unix?
lookup transformation with screenshots
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me