How IN function works in informatica? Is it similar that of oracle IN function

How IN function works in informatica? Is it similar that of
oracle IN function or different? Explain

Question Posted / manojdubba

2 Answers
15073 Views
Mphasis, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How IN function works in informatica? Is it similar that of oracle IN function or different? Explai..

Answer / pradosh

yes,it is similar to oracle IN function

Is This Answer Correct ?

11 Yes

7 No

How IN function works in informatica? Is it similar that of oracle IN function or different? Explai..

Answer / ajay

we can't use IN operater in informatica

Is This Answer Correct ?

6 Yes

19 No

Post New Answer

More Informatica Interview Questions

How many transformations can be used in mapplets.

0 Answers

can we generate reports in informatica ? How?

3 Answers

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers

How/where can i install Informatica software with oracle or teradata as database

0 Answers

why we use stored procedure transformation?

4 Answers IBM,

what is bridge tables in informatica

1 Answers CTS,

How can you generate reports in informatica?

0 Answers

Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers

What are conformed dimensions?