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.
- 0 Answers
- 2796 Views
- IBM, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How can you access the remote source into your session?
difference between stop and abort
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
How does the server recognize the source and target databases. Elaborate on this.
write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000
What is IQD file?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
In real time scenario where can we use mapping parameters and variables?
how can we convert a column into row in informatica? Eg: INPUT- a x Output Like: a b c b y x y z c z
Which will beter perform IIf or decode?
In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data
if soource is having 10 records how will u insert 20 records to target
Teradata 
