IBM Informatica Interview Questions Answers, IBM Placement Papers, IBM Technical, HR Interview Questions, IBM Aptitude Test Questions, IBM Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

IBM Informatica Interview Questions

Questions Answers Views Company eMail

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 8167

what is the significance of newlookup port in dynamic look up

1 6245

how many ways can we implement SCD2?

4 15619

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 5977

how may sources can be used in a mapping at a time?(limit)

6 9483

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

3 10089

suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 13037

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 4900

lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?

5 8247

differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??

2 6125

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 5105

every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.

1 5023

if i am having 10 records in source, i want 20 records in target...how will you do it

13 18071

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 21213

There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query

7 12423

Post New IBM Informatica Interview Questions

IBM Informatica Interview Questions

IBM Informatica Interview Questions (179)

Un-Answered Questions

What is difference between weblogic and tomcat?

893

Explain Risk Analysis?

1169

I want to test a mobile software by an automation tool which is a IP telephony based software designed for both ios and android phone, basically this apps is develop for make call though few low cost audio codecs from Aircraft to Ground and Ground to Aircraft so anyone can suggest me which testing tool we can use for it

2546

What do you mean by etl?

What is the Difference Between Primary and Foreign Key?

956

where can i get the previous question papers for rrb section enginerr (civil)

2289

Can I resolve the uri used as an xml namespace name?

805

Campaign mgt wt you know? Wt are the settings will you do?

1956

what are the master data in sap crm?

1001

Gave a cantilever beam with 3 legs.Told to draw the bending moment diagrams, axial force diagrams and shear force diagrams.From BMD he asked to show how the reinforcement will be provided on the tension side.

2918

How the cellular phone is working?

2019

How many types of operators python has?

865

What is ip spoofing and how can it be prevented?

870

Define acute disease?

886

How does select query work?

857