Interested to Buy Any Domain ? << Click Here >> for more details...
In operator is used in which transformation in informatica 8.6.0
- 5 Answers
- 20506 Views
- Virtusa, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nag
Hi,
I hope this will work in SQL Transformation.
Thanks and Regards,
Nag
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / balanri
Expression Transformation of Informatica provides all kinds
of functions which also includes Userdefined functions. We
can also use defined variables in this.
Operators also included in this as functions.
Informatica Expression transformation provides this IN
Operator.
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / 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 |
Answer / sudha
I guess that the IN operator can used in Aggregator
transformation. Not sure if any know exact answer plz post..
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / sarat
IN is a n operator used to filter the records, that should participate in O/P or to be rejected.
So thats the reason, i think its Filter/Router
| Is This Answer Correct ? | 1 Yes | 7 No |
how can import the data from the flat files?
What is informatica? What exactly are the practical uses in real world
What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1
i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
What is complex mapping?
How to open an older version of an object in the workspace?
How will u pas the data with out debugger?
Informatica settings are available in which file?
Tell me about Propagate functions in informatica
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.
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
Teradata 
