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 remove 1st 3 records & last 3 records in informatics

TetraSoft,

4 9996

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

TCS,

2 5560

write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null

TCS,

1 5207

what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull

IBM,

2 17158

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

IBM,

1 2050

What is instream data in SAS?

1 5084

what is in stream data in SAS?

1 6766

what is study design in while working with SAS? what are screening variables in SAS?

MSCR,

1 2294

how to handle in stream data containing semicolon in it?

3 6667

which stats created by proc means that are not created by proc summary or vice versa?

GSK,

2 6533

What are types of transport files?

PRA Health Sciences, Quintiles,

3 8116

How to convert .xls file into CSV format?

Quintiles,

6 23162

How to get any kind of data in SAS? Is it possible to take data from notepad in SAS?

GSK, TNS,

7 12941

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

1 2461

If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?

TCS,

1 7364


Un-Answered Questions { Data Warehouse }

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

4248


How to create the source and target database connections in server manager?

1139


what are the dimensions that you have in your current project?list them?

2085


explain in detail about type 3?

1078


how to generate the test data in sas without input data? : Sas-administrator

1194


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3648


Write the unconnected lookup syntax and how to return more than one column.

1164


What is node? How many nodes and amps used in your previous project?

1167


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2790


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2759


What are the data types present in bo? What happens if we implement view in the designer and report?

1076


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

1070


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

2253


faq's on cognos

4108