In operator is used in which transformation in informatica 8.6.0
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 |
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
What are the types of lookup?
What is the term PIPELINE in informatica ?
Enlist the differences between database and data warehouse.
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the types of schemas we have in data warehouse and what are the difference between them?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
What is the way to execute pl/sql script using informatica mapping?
What are the new features of informatica 9.x in developer level?
Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....
What are the types of groups in Router transformation?