Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

Patni,

5 10449

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

Patni, Tech Mahindra,

2 9850

how lookup is acting as both active and passive ? how is it possitble?

TCS,

9 61294

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

CTS,

6 9053

what is work of PUSH DOWN option

Wipro,

2 7409

who to split dimentions into sub dimention

Wipro,

3 7475

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 4352

what is DSS?

3 6301

how to identify new and old values in source qualifier or any other transformations using informatica

2 6058

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 27827

i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

Wipro,

3 7171

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

Mphasis,

2 6754

What is the difference Between Mapping parameter and variable

Accenture,

3 10603

What is update override?

Accenture,

1 6967

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

Accenture,

6 14878

Post New Informatica Questions

Un-Answered Questions { Informatica }

how to create user defined function (udf) in informatica

1307

What are the issues you have faced in your project? How did you overcome those issues?

2365

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1282

explan ur project architecture?

2069

Is it possible to create multiple domains on a single Informatica server?

1242

What are pre and post-session shell commands?

1311

According to his methodology what all you need before you build a datawarehouse

1759

difference between informatica 8.1.1 and 8.6

3677

Define mapplet?

1013

What are the different versions of informatica?

1275

What are the types of presistent cache in look up tr.

2055

What is meant by LDAP users?

1209

Can we create a node as a gateway node and the same node can be assigned to a grid?

1079

Can u generate reports in Informatica?

1089

Enlist the advantages of informatica.

1068

For More Un-Answered { Informatica } Questions Click Here