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

How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks

Puma,

2 4993

What is flashback table ? Advance thanks

Puma,

1079

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 34287

What is version control in informatica ? Advance thanks

HCL, Puma,

6 13787

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

Puma,

6 6895

Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation

Puma,

1 11464

Can we write to_date(three arguments) ? Will it work ? Advance thanks

Puma,

1 4901

can we send mail when ever it get success or faulure to other mailid?(Not company mail id)

Puma,

1 2996

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

Puma,

4 6174

What is the difference between lookup override and souce qualifier override ?

Puma,

2 12950

As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?

1 2875

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

1250

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 7727

What is the role of informatica in project ?Like i showed financial projects?

Amdocs,

1 1825

Why we require dwh in particular projects?

Amdocs,

1 3728


Post New Informatica Questions






Un-Answered Questions { Informatica }

What is informatica worklet?

214


Which version configuration tool used in ur project?

2337


Enlist few areas or real-time situations where informatica is required.

218


How do we call shell scripts from informatica?

221


Difference between Target-based loading and constraint-based loading?

211






What do mean by local and global repository?

262


Target increases every day even though no new record was inserted

621


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

507


What is a snowflake schema?

209


What is joiner transformation in informatica?

246


can we override a native sql query within informatica? How do we do it?

223


How to start a workflow using pmcmd command?

273


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

269


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

206


What do you mean by channel change?

202