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

i have one source 52 million records i want target only 7 records ?how wil you do what logic to implement?

L&T,

7 11649

i have ten flat files with same structure,if i want to load it to single target,and mapping needs to should show only one source.what will be the steps to taken to achieve it?/

L&T,

5 10423

if i have a file having record sal=10000,and when use router with two groups having condition sal>5000 in one group,sal>7000 in other group.and if two groups connected to two targets.in which target sal=10000 will go?

BirlaSoft, Genpact, L&T, Syntel,

9 14459

can we see default group,when we use router?if yes how?

L&T,

2 6478

what is left outer join?

L&T,

3 7093

when we use dynamic lookup,if condition matches what will be the o/p?

L&T,

2 7321

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

L&T,

5 10586

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

L&T,

11 30637

source : col1 101 101 101 102 102 102 103 103 103 col2 1000 1500 2000 1200 2300 3000 2400 1300 2000 i need target as col1 101 102 103 col2 1000,1500,2000 1200,2300,3000 2400 1300 2000

CTS, Wipro,

6 9189

Target is zero file and how can you send the email?

Bank Of America,

2 10373

By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

 8 16527

hi,there is a scenario like. there are three columns empid,salmonth, sal contains the values 101,jan,1000 101 feb 1000 like twelve rows are there then my required out put is like contains 13 columns empid jan feb marc.......dec and the velues are 101 1000 1000 1000 like this . thank you

Patni,

5 8424

how to remove staging area

 1 4833

When we are using Dynamic Cache,which options we will select in session level?

Cognizant, CTS,

1 3523

h0w many versions have been developed of onformatica so far?

TCS, TetraSoft,

1 2401

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we remove the duplicates from flat file source?

564

What is event and what are the tasks related to it?

598

How to create or import flat file definition in to the warehouse designer?

600

What are active and passive transformations?

636

Explain the informatica workflow?

575




Explain what are the different types of transformation available in informatica.

559

Explain how many types of dimensions are available in informatica?

577

is it possible to index the data in cache of lkp transformation ?

1511

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2047

What is a stored procedure transformation?

601

How will the document be delivered to me?

607

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6742

How can we improve session performance in aggregator transformation?

657

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1536

What is DR strategy for Informatica project?

683

For More Un-Answered { Informatica } Questions Click Here