Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 7013

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 6827

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

TCS,

9 48118

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

CTS,

6 5605

what is work of PUSH DOWN option

Wipro,

2 5134

who to split dimentions into sub dimention

Wipro,

3 4955

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 2964

what is DSS?

3 3999

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

2 4109

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

4 23863

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 4880

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

Mphasis,

2 4373

What is the difference Between Mapping parameter and variable

Accenture,

3 7617

What is update override?

Accenture,

1 4798

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 10836


Post New Informatica Questions






Un-Answered Questions { Informatica }

Where do we use mapping variables in informatica?

192


What are batches?

176


What are the transformations that are not supported in mapplet?

171


if we have a delimiters at unwanted places in a flat file how can we over come those.

1132


Can we use the mapping parameters or variables created in one mapping into another mapping?

266






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

193


What is a connected transformation?

244


How will the document be delivered to me?

177


Differentiate between router and filter transformation?

160


What is the difference between informatica 7.0 and 8.0?

181


In informatica workflow manager, how many repositories can be created?

184


How to use pmcmd utility command?

173


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

205


What is a router transformation?

205


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1031