Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Post New Answer

More Informatica Interview Questions

Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


What is workflow monitor?

0 Answers  


What is the fact table?

0 Answers  


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...

6 Answers   TCS,


Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,


can we generate reports in informatica ? How?

3 Answers  


what is constraint based load order

2 Answers   Cap Gemini,


What is critical mapping?

2 Answers  


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?

9 Answers   IBM,


Clarify the utilization of aggregator cache record?

0 Answers  


What is informatica metadata and where is it stored?

0 Answers  


How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,


Categories