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 8280

what is the significance of newlookup port in dynamic look up

1 6337

how many ways can we implement SCD2?

4 15843

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 6137

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

6 9762

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

3 10272

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 13344

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 4986

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 8443

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 6271

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

1 5219

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 5122

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

13 18638

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

4 21460

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 12703

Post New IBM Informatica Interview Questions

IBM Informatica Interview Questions

IBM Informatica Interview Questions (179)

Un-Answered Questions

Dear all, I just want to ask an expert on this forum for some insights. For the magnetic balance test, when applied voltage on a Delta-Star transformer e.g. Dyn11, the following relationships apply for HV side: 1. H1-H2 = H2-H3 H3-H1 2. H2-H3 = H3-H1 H1-H2 3. H3-H1 = H1-H2 H2-H3 For the LV side also: 4. X1-X0 = X2-X0 X3-X0 5. X2-X0 = X3-X0 X1-X0 6. X3-X0 = X1-X0 X2-X0 Is there a similar pattern for Y-d, Y-Y, D-d? And how about Y-z, D-z, Z-y transformers? I've tested a YNzn5 transformer and for LV side I don't see the pattern. In this particular case I got for LV side the following (see values below): H1-H0 H2-H0 H3-H0 X0-X1 X0-X2 X0-X3 128.0 119.9 7.2 29.2 13.3 15.8 70.7 128.4 59.2 23.4 22.0 3.6 7.2 120.1 128.1 13.4 29.3 15.8 What is the relationship here for LV? For row 1 I see the relationship, for row 3 I also see but it's shifted, but for row 2 I don't see such relationship. Any suggestions, answers, someone?

1873

What are newton s laws of motion?

1062

List some opensource libraries for nlp?

818

What is the function of a dd statement?

1211

What main components of android application?

1004

How a tablespace is related to data files?

1109

Where can the code for an app run?

793

How will you prove your worth to the company and how will the company benefit if we hire you?

1052

Difference between Pure functions Vs. Impure functions in javascript?

1007

What does while 1 mean in python?

795

Why does Oracle not permit the use of PCTUSED with indexes?

2426

What is the function lucene?

223

Define garbage collection?

1038

What is difference between fileinputstream and filereader in java?

1072

Explain how to enable multiple php versions in homestead?

658