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 |
What is olap (on-line analytical processing?
What is a passive transformation?
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
How can we integrate different flat file data in a single mapping and with in a single execution
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
what is data driven in informatica
What are the differences between joiner transformation and source qualifier transformation?
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
According to his methodology what all you need before you build a datawarehouse
How Union Transformation is an Active Trans?