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.
- 0 Answers
- 2586 Views
- IBM, I also Faced
- E-Mail Answers
what is bitmap index? did u use it?and how to use it in informatica
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
Two different admin users created for repository are ______ and_______
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Why do we use DSS database for OLAP tools?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
Which transformation should u need while using the cobol sources as source defintions?
What are the designer tools for creating transformations?
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
How the informatica server sorts the string values in Rank transformation?
Teradata 
