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

Informatica Interview Questions

Questions Answers Views Company eMail

what happens when a batch fails?

3 8255

connected and unconnected lookups?

4 8448

what is scd?

6 17519

what are surrogate keys?

5 11327

how do u tune queries?

1 6487

what is metadata?

6 9957

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 11794

what is the difference between onsite & client site?

1 10353

we have a parameter file in Unix location where we have .txt files and those file will be used as source in informatica. I cannot use source file name directly as file name will keep on changing in unix location. I need to define $$InputFile as parameter. Can anybody send me the parameter file and the steps to handle this.

Infosys, TCS,

2 18066

how the server recognises , if the session fails after loading the 100 records in to the target

TCS,

2 10010

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

Altisource, TCS,

14 23910

if the session fails after 100 records agian we have to starts the session or we go for recovery session

TCS,

2 10247

How do you take care of security using a repository manager

2 8102

Can you use one mapping to populate two tables in different schemas

2 9473

What are differences between Informatica 7.1 and 6.1

3 10689

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the settings that you use to configure the joiner transformation?

1008

How you prepared reports for OLAP?

1560

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1851

How to improve the performance of a session using sorter transformation?

1098

How to start a workflow using pmcmd command?

1191

How to implement security measures using repository manager?

1092

What is the difference between router and filter?

1170

Differentiate between joiner and lookup transformation?

1058

What are the different lookup cache(s)?

1041

What is a dimensional model?

934

can u any challenge your project?

1977

What is DR strategy for Informatica project?

1124

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

1935

Is it possible to define a single node as a Gateway node as well as worker node?

1067

What are the types of caches in lookup?

981

For More Un-Answered { Informatica } Questions Click Here