Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Informatica Interview Questions
Questions Answers Views Company eMail

how can we perform incremental aggregation?explain with example?

IBM, TCS,

9 23913

How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?

2 8437

Can you please mail me a copy of Informatica Certification Exam dumps to r_balakrishna@yahoo.com

21 27475

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

Infotech,

3 8194

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

IBM, Infotech,

4 36328

Why we need XMLs?

IBM,

3 8008

What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

CTS,

5 46250

Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.

CTS,

2 9232

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 23168

How many mapplets u have created? and what is the logic used

Mind Tree,

5 12101

why do we go for update strategy tr in SCD rather using the session properties?

IBM,

3 17121

How to transform normalized data to denormalized form in informatica? Is there any logic or any transformations to achieve this?

3 29269

How/where can i install Informatica software with oracle or teradata as database

2508

Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)

1 5055

There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??

TCS,

9 14764


Post New Informatica Questions

Un-Answered Questions { Informatica }

Which transformation is needed while using the Cobol sources as source definitions?

1224


What are mapplets? How is it different from a Reusable Transformation?

1139


What is a node in Informatica?

1087


What does refresh system mean, and what are its distinctive choice?

1275


tell me the rules and responsblites in our project(my project is development)

1984


Whats there in global repository

1741


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

2014


Briefly describe lookup transformation?

1099


Explain the different lookup methods used in informatica?

1098


Define filter transformation?

1150


Explain how many types of dimensions are available in informatica?

1175


What is mapping debugger?

1070


What is meant by pre and post session shell command?

1203


What are the different components of powercenter?

1119


Explain constraint based loading in informatica

1157