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 7367

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 3112

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 8944

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

TCS,

2 11989

What are Rapid changing dimensions?

1 5581

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 14375

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

L&T,

2 7578

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

Mind Tree,

3 9967

what are objects in data warehouse?

Mind Tree,

2 8529

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

1 4490

design of staging area?

1 2103

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

TIAA CREF,

3 17628

How to find value from a column in a dataset?

TIAA CREF,

1 2273

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

TIAA CREF,

2 7925

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 7740


Un-Answered Questions { Data Warehouse }

Explain about a tricky situation for which you found a very simple solution?

1081


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2154


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6082


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2346


Just Completed the informatica Certification ,for Dumps please email me on infamaddy@gmail.com i will send it to you 

1772


faq's on cognos

4116


What is the purpose of Dataware Control?

1121


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2086


Explain about a time when you discovered a more efficient way to do a work task?

1224


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2069


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2497


What is rollup component?

1344


What is dimensional table? Explain the different dimensions.

1273


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1673


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1214