In operator is used in which transformation in informatica 8.6.0

Answer Posted / n.prasad

we can use In operator in source qualifier and sql
transformation if the source tables belongs oracle.otherwise
we cannot use in operator in informatica transformation.

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Create a folder using pmrep command?

632


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.

2332


What is update strategy transform?

590


Why union transformation is an active transformation?

665


What are the differences between source qualifier and joiner transformation?

606






hi real timers . iam waiting for ur reply regarding ETL TESTING

1819


What does refresh system mean, and what are its distinctive choice?

580


What all are steps in up gradation of Informatica server?

629


What is session task and command task?

659


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1334


What is workflow? What are the components of the workflow manager?

652


Explain dynamic target flat file name generation in informatica

656


Explain lookup transformation source types in informatica

709


What are the types of data warehouses?

956


explan ur project architecture?

1608