Interested to Buy Any Domain ? << Click Here >> for more details...
In operator is used in which transformation in informatica 8.6.0
- 5 Answers
- 20419 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 is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
Can a joiner be used in a mapplet.
On which transformations you created partitions in your project?
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
What is different between the data warehouse and data mart?
What is the difference between normal and bulk loading? Which one is recommended?
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is the difference between Bulk Load and Normal Load
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
what is scd?
Mapplets can you use an active transformation in a mapplet,
Teradata 
