In operator is used in which transformation in informatica 8.6.0
- 5 Answers
- 18742 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 |
What are the performance considerations when working with aggregator transformation?
What is the Process to creating lookup transformation in informatica
Define error Threshold?
Enlist the tasks for which source qualifier transformation is used.
What is the function of look up transformation?
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What are the types of lookup?
When will you use SQL override in a lookup transformation?
What is the difference between Active and Passive transformation?
How we can use union transformation?
Teradata 
