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 difference between Mapplet and reusable transformation?
How to jion 2 tables, without using any condition?
What is the difference between router and filter?
Explain sessions. Explain how batches are used to combine executions?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
Router T/R is active but some people are saying it is also passive which is exactly right?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Can we have a Mapping without a Source Qualifier?
What is Index Caches size?
Major difference between SQL override and Lookup Sql override
WAT IS TEXT LOAD?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???