1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

performance wise which one is better in joiner and lookup transformation

 2 5695

which transformation uses cache?

Keane India Ltd,

3 5847

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 5979

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 6708

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 7166

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

Keane India Ltd,

2109

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

emc2,

2 4340

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 10622

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 7993

can any one explain me about junk dimension

 4 5199

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

 2 4537

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 4313

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 9830

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 6852

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 5197

Post New Informatica Questions

Un-Answered Questions { Informatica }

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1038

generate date / time dimension in informatica

709

What is sq transformation?

652

Is it possible to revert a global repository to local one and why?

604

What is domain and gateway node?

683




Explain the types of transformations?

588

what is the hint? how to use it to reduce the query processing in program?

6269

What is meant by LDAP users?

684

As union transformation gives UNION ALL output, how you will get the UNION output?

635

What is confirmed fact in dataware housing?

5651

What is an unconnected transformation?

654

What is meant by query override?

627

What is the benefit of session partitioning?

584

Explain the difference between a data warehouse and a data mart?

590

Where do we use mapping variables in informatica?

602

For More Un-Answered { Informatica } Questions Click Here