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
Two different admin users created for repository are ______ and_______
What are the features of complex mapping?
What are mapplets? How is it different from a Reusable Transformation?
what are the difference between Informatica 7.1 and 8.1?
tell me the push down optimization
To provide support for Mainframes source data,which files r used as a COBOL files
Hello...... How can i set my mapping as read-only? Please answer me. Advance thanks
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
without matching columns in two tables. how can you join
What is meant by a domain?
Does an informatica transformation support only aggregate expressions?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?