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
Define mapping and session?
Explain what transformation and how many are there in informatica?
Explain lookup transformation is active in informatica
In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?
what are the limitations for bulk loading in informatica for all kind of databases and transformations?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
write a query for how to eliminate the duplicate rows without using distinct?
When we enable pushdown optimization technique, two options will be enabled (use view,..). Can anyone tell me how these two options will work ? When do we need to go for pushdown optimization technique ?
Explain the use of aggregator cache file?
How do you implement unconn. Stored proc. In a mapping?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is sorter transformation?