Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

performance wise which one is better in joiner and lookup transformation

2 6686

which transformation uses cache?

Keane India Ltd,

3 7430

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

emc2,

2 7110

In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

emc2,

3 8152

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

Cognizant, emc2,

2 8427

Explain Dataware house architecture .how data flow from intial to end?

Keane India Ltd,

2654

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

emc2,

2 5420

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?

IBM,

9 13596

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

Cognizant,

3 9660

can any one explain me about junk dimension

4 6871

where actually the usage of push down optimization happens...

2 5628

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?

IBM,

1 5067

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

3 11086

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?

IBM,

5 8624

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 ??

IBM,

2 6363


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the types of lookup transformation?

1121


can we override a native sql query within informatica? Where do we do it? How do we do it?

1115


What is meant by incremental aggregation?

1187


Explain the types of lookup transformation?

1109


What is target load order?

1302


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1691


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2059


What is deployment group?

1304


Define update strategy?

1322


complex mapping ur project u r invlve can u explain and give real time example give me ?

2353


What is a shortcut and copy in Informatica and how two are different with each other?

1245


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

2053


What is a pre-defined event and user-defined event?

1088


What are the tasks that source qualifier perform?

1145


can anyone explain me about retail domain project in informatica?

8005