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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

Amdocs,

3 17623

What is the difference between warehouse key and surrogate key?

Accenture,

1 6673

what are the limitation of sorter transformation?

TCS,

2 12819

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

Wipro,

4 8386

Why should we use star schema in datawarehouse design?

Wipro,

2 5995

What is the difference between informatica 8.x and 9.x

Wipro,

1 12774

WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

 1 4876

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 16375

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

Amdocs,

1 6905

tell me the push down optimization

Wipro,

2 5666

tell me the informatica architecture

Banca Sella, Wipro,

1 5602

how we can load rejected record's at run time?(not through bad files)

TCS,

2330

what is row level and column level indicator?

TCS,

1 7431

what is the method of error handling when session is running?

TCS,

1 6195

can we use bulk loading when we use look in mapping

TCS,

1 3584

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is the size of u r source(like file or table)?

2225

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4692

What is workflow manager?

1004

How to create or import flat file definition in to the warehouse designer?

1039

What are connected or unconnected transformations?

1068

What do you mean by worklet?

1033

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6073

How to do unit testing in informatica? How to load data in informatica ?

1061

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2699

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

1860

Could you explain what is enterprise data warehouse?

1077

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1070

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

1026

What is sorter transformation?

998

Performance tuning( what you did in performance tuning)

1930

For More Un-Answered { Informatica } Questions Click Here