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

Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

IBM,

1 4493

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 2430

How to use Normalizer transformation?

2 3460

what are the limitations for bulk loading in informatica for all kind of databases and transformations?

Accenture, CSC,

3 11960

when we dont use aggregator in mapping ?

CSC,

2 4648

what is workflow varible

HP,

1 4378

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

IBM,

4 14726

If we set dd_insert in mapping and Delete in session properties what will happen.?

IBM,

4 5317

Is it possible to update the target table with PK?

TCS,

1 4744

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 3640

In aggregator if u enable sorted input what will be the output and disable sorted wt is output

6 8672

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

IBM, TCS,

3 6373

What is target update override

CTS,

2 5585

One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?

HCL,

5 8828

sorce is a flatfile only 1st and last row should insert to target how will u do?

HCL,

2 6266


Post New Informatica Questions






Un-Answered Questions { Informatica }

How union transformation is used?

184


Differences between connected and unconnected lookup?

173


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

1031


What are the different components of powercenter?

187


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1213






How can we use mapping variables in informatica? Where do we use them?

173


What is difference between a gateway node and worker node?

201


How to implement security measures using repository manager?

189


Can we change Dynamic to Static or Persistent cache? If so what happens?

1258


design of staging area?

1124


How to load the name of the current processing flat file along with the data into the target using informatica mapping?

210


What are the databases that informatica can connect to windows?

190


How we can confirm all mappings in the repository simultaneously?

179


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

459


What is the use of an aggregator cache file?

214