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 8600

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 8650

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

TCS,

9 57068

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

CTS,

6 7193

what is work of PUSH DOWN option

Wipro,

2 6191

who to split dimentions into sub dimention

Wipro,

3 6337

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 3698

what is DSS?

3 5062

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

2 4999

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

4 26307

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 5987

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

Mphasis,

2 5492

What is the difference Between Mapping parameter and variable

Accenture,

3 8979

What is update override?

Accenture,

1 5845

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 12661


Post New Informatica Questions

Un-Answered Questions { Informatica }

Define sessions in informatica etl?

600


what is index?how it can work in informatica

1553


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

1744


What is an Integration service in Informatica?

680


In which transformation you cannot drag ports into it?

757






Where do we use mapping variables in informatica?

596


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1610


What is meant by LDAP users?

669


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1582


tell me the rules and responsblites in our project(my project is development)

1472


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1292


Is there any target staging area in informatica not staging area

2101


How do you update the records with or without using update strategy?

634


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7735


What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

533