hw cn v elimate dublicate values from lookup without
overriding sql?
Answer Posted / surender
yes correct
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What are ETL Tools?
Explain scd type 3 through mapping.
What are the types of lookup transformation?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is the advantage of informatica?
How do you update the records with or without using update strategy?
How an expression transformation differs from aggregator transformation?
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.
How to update source definition?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What are the differences between oltp and olap?
What are the tasks that can be performed using sq?
What if the source is a flat-file?