Diff b/w Crossproduct and Outerjoin?

2281

If you could design your ideal job, what would it look like?

2931

Did you write stored procedures in teradata?

1132

How would you define the end of a macro?

1093

What is primary and backup node?

1127

Difference between project merge and object manager in microstrategy?

993

what are the major three types of modeling used?

1067

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1075

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1007

How many tables can you join in v2r5?

1072

For faster process, what we will do with the universe?

990

What is a table alias in obiee? And where and how will you create it.

900

--------------Explain Table of contents?

2024

What are the different log files in obiee?

962

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.

2859