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
what is mean by throghput? in informatica
Can anyone please distinguish what is Inner join and Outer join
what is inline view?
comonly how meny mappings r there in Banking projects?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
what is the location of parameter file in informatica?
How can you change from reusable session into non-reusable session.
source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009
Is it possible to define a single node as a Gateway node as well as worker node?
in realtime which situations u can use unconnected lookup transformation
If u select groupby port in aggregator what is output and dont select groupby option what is output
What is dynamic cache?