Interested to Buy Any Domain ? << Click Here >> for more details...
In operator is used in which transformation in informatica 8.6.0
- 5 Answers
- 20682 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 |
In dimension and fact table? which one holds big data?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
i have source in oracle 10g,oracle 8i how will u take the data from two sources
Explain the types of lookup transformation?
Where should yoU place the flat file to import the flat file defintion to the designer?
While migrating the data from one environment to another environment how would you manage the connections?
What are active and passive transformations?
What is the procedure for creating independent data marts from informatica 7.1?
How/where can i install Informatica software with oracle or teradata as database
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
Teradata 
