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

h0w many versions have been developed of onformatica so far?

TCS, TetraSoft,

1 3191

In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?

Patni,

5 10658

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

Patni, Tech Mahindra,

2 9990

What are Dashboard reports?And significance of these in analysis?

1 2963

How to get top scorer student from a class-table having different sections A,B, C & D? Each section having same number of students.

2 5719

How to get second top scorer student from a class- table having different sections A, B, C & D? each section has same number of student.

TCS,

4 8868

how lookup is acting as both active and passive ? how is it possitble?

TCS,

9 61698

can any one pls send me the project flow at the time of interview

2330

can any one tell me how to create a new universe from scrach with step by step process.

HCL,

4 9672

How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?

Reddy Labs,

3 7744

what is the primary variable in your study?

Accenture,

3 15819

what are all the reports you generated in your recent project?

Accenture, Quintiles,

1 2260

Did you used proc test? when?

Accenture, Quintiles,

1 2099

Did you used proc lifetest? when?

Accenture, Parexel, Quintiles,

2 10663

In proc transpose and data step with arrays which one you pick?

Accenture, Quintiles,

1 3191


Un-Answered Questions { Data Warehouse }

Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks

2089


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1194


What is dimensional table? Explain the different dimensions.

1262


Connecting to iserver volume using idapi classes(java classes) and after connecting to iserver I want to execute the rox on iserver and also want know the status whether that job is succesfully run or not?

1095


How do you remove duplicate records in informatica? And how many ways are there to do it?

1224


Explain in detail about scd type 1 through mapping.

1641


explain in detail about type 3?

1078


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

1164


Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1026


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

2760


create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2798


can any one help me now i am learning AB Inito but i don't have material and pdf's can any one provide pdf's to this mail id mohanraju0113@gmail.com thanks in advance...................................

2324


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2169


what are the names of the reports that you prepared?

1185


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

4253