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

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  


A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.

1 Answers   TATA,


Explain the flow of data in Iinformatica?

1 Answers  


How to compare Source and Target table, without using dynamic lookup?

4 Answers  


What are the data movement modes in informatcia?

1 Answers  


What is a passive transformation?

0 Answers   Informatica,


What is the difference between view and materialised view?

4 Answers  


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


What is a command that used to run a batch?

4 Answers  


What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


permutations of mapplet

0 Answers   TCS,


Categories