Interested to Buy Any Domain ? << Click Here >> for more details...
In operator is used in which transformation in informatica 8.6.0
- 5 Answers
- 20697 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 |
i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Tell me about Propagate functions in informatica
What does role playing dimension mean?
What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?
What is a repository? And how to add it in an informatica client?
Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?
define galaxy repository in informatica
Difference between task flow and linear task flow
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
in which situations do u go for starflake schema ?
Teradata 
