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
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?
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.
Explain the flow of data in Iinformatica?
How to compare Source and Target table, without using dynamic lookup?
What are the data movement modes in informatcia?
What is a passive transformation?
What is the difference between view and materialised view?
What is the main difference between a Joiner Transformation and Union Transformation?
If we have lookup table in workflow how do you trouble shhot to increase performance?
What is a command that used to run a batch?
What is the difference between SOURCE and TARGET BASED COMMITS?
permutations of mapplet