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


Please Help Members By Posting Answers For Below Questions

Why union transformation is an active transformation?

630


Which transformation is needed while using the Cobol sources as source definitions?

704


What are ETL Tools?

647


Explain scd type 3 through mapping.

557


What are the types of lookup transformation?

605






What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1610


What is the advantage of informatica?

624


How do you update the records with or without using update strategy?

634


How an expression transformation differs from aggregator transformation?

599


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.

2292


How to update source definition?

607


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?

762


What are the differences between oltp and olap?

527


What are the tasks that can be performed using sq?

590


What if the source is a flat-file?

568