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



Data Warehouse Interview Questions
Questions Answers Views Company eMail

How to merge the data using merge statement and proc format? Is the result is same ?

2 7218

Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?

IBM,

1 3012

After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

TCS,

3 8770

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

TCS,

2 11834

What are Rapid changing dimensions?

1 5445

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

IBM,

9 13995

Which one is better among Value and select & search prompts,in terms of performance?

L&T,

2 7434

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

Mind Tree,

3 9817

what are objects in data warehouse?

Mind Tree,

2 8422

what are challenges that you faced in testing? give solution to it?

1 4414

design of staging area?

2040

how can you generate sequence number using only the sequential file stage?

TIAA CREF,

3 17456

How to find value from a column in a dataset?

TIAA CREF,

2222

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

TIAA CREF,

2 7783

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

TIAA CREF,

1 7600


Un-Answered Questions { Data Warehouse }

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1100


4. How many dimensions did you use in your reports?

1962


What is logical data model?

1216


What all join we can perform in LOOKUP transformation?

996


hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..

1913


What is the main difference between schema in rdbms and schemas in datawarehouse?

1102


Explain 4gt switch. Does it have any drawback?

982


What are universe requirements?

1064


What do you mean by fastexport in teradata?

1017


-------------What is Coditional Prompting?

2168


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2534


tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

844


How do we resolve attribute roles in microstrategy?

1164


a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

2477


Why need staging area database for dwh?

1089