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

Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 3134

how do you pull data from equifax?tell me the process?

Synchrony Financial,

1808

what are the three main credit bureau names

Synchrony Financial,

1 3029

How can you join two tables without any common column present in them?

TCS,

1 3710

List the various vector functions used in ab initio with syntax.

1 19080

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1765

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1789

What is difference between Union and Union All ?

L&T,

1 3458

Explain your project of banking domian.

Cap Gemini,

1655

What are the difference between merge,auto merge and extended merge ?

Cap Gemini,

1 2818

Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS

Accenture, HSBC,

1 3019

i have 2 files. First file contains a,b,c,d as rows and second file contains 1,2,3,4 as rows. how do we make single a1b2c3d4 and 4 different rows a1, b2, c3,d4.

L&T,

4 11664

how to insert header after each group.

IBM,

1 3049

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1917

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

CTS,

1638


Un-Answered Questions { Data Warehouse }

What is data modeling and data mining?

982


what is universe null

2430


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4115


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

2150


What exactly do you understand with the term data processing and businesses can trust this approach?

1111


how do you manage the production space. what are the proactive methods you can take ?

1952


What junk dimension contains?

1000


What are batches?

1107


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2195


What are the tasks that source qualifier perform?

1108


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2191


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1987


Difference between multiload and tpump?

1119


how will you locate the sas platform applications? : Sas-bi

1035


What are the various kinds of the hash file?

1152