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

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1 2125

Why we use parameters instead of hard code in datastage.

IBM,

2 7876

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

Infosys, TCS,

1 5833

How can we do null handling in sequential files?

Reliance,

3 18082

can we half project in parallel jobs and half project in server jobs?

Infosys, L&T,

4 11031

what are the different type of errors in datastage?

Wipro,

2 9260

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 10079

Can we use unconnected lookup as dynamic lookup?

TCL,

1 4226

Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 8719

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1 2061

What is the difference between writing a joiner query in ANSI style and THETA style?

TCS,

1 2465

Why we select the table which has minimum number of records as Master table in joiner?

HG, UST,

4 20176

can we use mapplet as starting n ending object in mapping

TCS,

2 5934

what is the predefined port in dynamic lookup

2 6289

What is SAS? is it a software just for use or we can creat something over there?

Cognizant,

5 9252


Un-Answered Questions { Data Warehouse }

Explain how to generate iqd file from framework manager?

1022


How would you format some text using css to be verdana and bold?

1150


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2108


faq's on cognos

4114


What is dimensional table? Explain the different dimensions.

1272


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.

2817


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

1179


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)

2796


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

1964


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

1144


What is aggregate table and aggregate fact table ... Any examples of both?

1120


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

3666


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

2772


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

1234


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

1044