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
Can yoU use the maping parameters or variables created in one maping into another maping?
What is workflow monitor?
What is the fact table?
I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...
Is snow flake or star schema used? If star schema means why?
can we generate reports in informatica ? How?
what is constraint based load order
What is critical mapping?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
Clarify the utilization of aggregator cache record?
What is informatica metadata and where is it stored?
How to load the data from a flat file into the target where the source flat file name changes daily?