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 17744

What is the difference between warehouse key and surrogate key?

Accenture,

1 6757

what are the limitation of sorter transformation?

TCS,

2 12897

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 8522

Why should we use star schema in datawarehouse design?

Wipro,

2 6086

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

Wipro,

1 12859

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 4936

What are the disadvantages of Sequence Generator T/R?

Zensar,

3 16497

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 6988

tell me the push down optimization

Wipro,

2 5751

tell me the informatica architecture

Banca Sella, Wipro,

1 5669

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

TCS,

2379

what is row level and column level indicator?

TCS,

1 7517

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

TCS,

1 6268

can we use bulk loading when we use look in mapping

TCS,

1 3656

Post New Informatica Questions

Un-Answered Questions { Informatica }

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1901

What is complex mapping?

1120

What is a joiner transformation and why it is an active one?

1080

What is lookup change?

1048

Design time, run time. If you don't create parameter what will happen

1837

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

What are the new features of Power Center 5.0?

1779

What is a standalone command task?

1204

How identifying bottlenecks in various components of informatica and resolving them?

1132

Explain sessions and how many types of sessions are there?

1009

Quickly characterize reusable change?

1119

What does command task mean?

1148

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1167

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1199

How to join three sources using joiner? Explain though mapping flow.

1147

For More Un-Answered { Informatica } Questions Click Here