Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 6427

what is the significance of newlookup port in dynamic look up

1 4855

how many ways can we implement SCD2?

4 12758

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 4096

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

6 6132





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

3 7876

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 8705

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 3694

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 5479

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 4148

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

1 3939

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 3935

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

13 12070

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

4 16512

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 8465

Post New IBM Informatica Interview Questions




IBM Informatica Interview Questions


Un-Answered Questions

What are functions in c#?

194


What is the next step after Mapper or MapTask?

192


How to Print a WEB page with the HTML control?

1322


What is rootscope in angular 2?

180


How do I open applicationhost config?

195






Explain the significance of routing? : asp.net mvc

212


What is fishbucket or what is fishbucket index?

69


How Spark uses Akka?

83


What are the steps to configure clustering in tomcat server?

198


Tell me data mover questions. Where did you use etc?

165


Tell us about your experience in licensing.

1464


Explain what do you understand by registers, briefly explain the various types of registers.

235


Explain trigger and trigger types?

228


What are LEAFs ?

1949


What is laravel vue?

168