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

what we require for D.modelling?

1 3412

how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.

CTS, Symphony,

6 14582

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

CTS,

1 7894

what is filelist concept in informatica

4 17640

If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?

4 7505

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 20600

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

Mastek,

6 8737

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 5060

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 5309

i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/

4 5513

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

Wipro,

3 7354

All active transformations r passive or not?

7 9054

how to load only the first and last record of a flat file into the target?

CTS,

8 26466

What is checksum termnology in informatica? Where do you use it ?

Chase, Cognizant, Deloitte,

3 25477

What is the term PIPELINE in informatica ?

Deloitte,

7 30402


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain what are the different versions of informatica?

452


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

424


What is a rank transform?

509


Explain the difference between a data warehouse and a data mart?

444


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

1318






What are the tasks that can be performed using sq?

459


What are the tuning techniques you applied during your last project

1389


What are session parameters ? How do you set them?

1182


can u any challenge your project?

1411


Explain scd type 3 through mapping.

424


What is session task and command task?

477


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

979


How to extract the informatica rejected data?

576


Describe the impact of several join conditions and join order in a joiner transformation?

466


EXL informatica Questions

753