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 17868

What is the difference between warehouse key and surrogate key?

Accenture,

1 6845

what are the limitation of sorter transformation?

TCS,

2 13004

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 8675

Why should we use star schema in datawarehouse design?

Wipro,

2 6188

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

Wipro,

1 12965

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 5024

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 16657

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 7075

tell me the push down optimization

Wipro,

2 5855

tell me the informatica architecture

Banca Sella, Wipro,

1 5756

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

TCS,

2433

what is row level and column level indicator?

TCS,

1 7603

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

TCS,

1 6331

can we use bulk loading when we use look in mapping

TCS,

1 3741

Post New Informatica Questions

Un-Answered Questions { Informatica }

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1386

Write the advantages of partitioning a session?

1337

In informatics server which files are created during the session rums?

1171

How to create a non-reusable instance of reusable transformations?

1174

What is workflow? What are the components of workflow manager?

1235

Explain scd type 3 through mapping.

1055

How many transformations can be used in mapplets.

1985

Why update strategy and union transformations are active?

1101

Explain the tuning lookup transformation - informatica

1049

What differs when we choose the sorted input for aggregator transformation?

1076

what is mean by complex business rule ?

2221

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1851

differences between service based and product based?

2060

is it possible to index the data in cache of lkp transformation ?

2081

What is mapping debugger?

1071

For More Un-Answered { Informatica } Questions Click Here