Can we use unconnected lookup as dynamic lookup?
Answer Posted / rakesh
thanks suresh, and can any one explain why(the reason)?
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is mapping debugger?
How to do unit testing in informatica? How to load data in informatica ?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How does a sorter cache works?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is sq transformation?
Describe the impact of several join conditions and join order in a joiner transformation?
If informatica has its scheduler why using third party scheduler?
Why union transformation is an active transformation?
How many number of sessions can one group in batches?
What is the difference between a connected look up and unconnected lookup?
Explain target update override in informatica
What are session parameters ? How do you set them?
whats the logic to load the lower level of granularity of data to fact table.
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.