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

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 6859

What is flashback table ? Advance thanks

Puma,

1948

what are the limitations of pushdown optimization technique ? Advance thanks

Puma,

3 41226

What is version control in informatica ? Advance thanks

HCL, Puma,

6 17816

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

Puma,

6 10321

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 14438

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

Puma,

1 6344

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

Puma,

1 4401

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

Puma,

4 9416

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

Puma,

2 15610

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

1 4309

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

2134

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

2 9931

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

Amdocs,

1 3313

Why we require dwh in particular projects?

Amdocs,

1 5242

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the use of code page?

1100

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9836

Partition, what happens if the specified key range is shorter and longer

2504

What is joiner transformation in informatica?

1054

What is the procedure for creating independent data marts from informatica 7.1?

1068

What is a sequence generator transformation?

1025

Explain the difference between mapping parameter and mapping variable?

1049

What is substr in informatica?

1217

Can anyone tell me the new features in Informatica 9 Version?

2140

What all are steps in up gradation of Informatica server?

1047

How to create Target definition for flat files?

1240

What is rank transformation in informatica

1185

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

1761

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2073

rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg

1972

For More Un-Answered { Informatica } Questions Click Here