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 many types of keys are there i.e primary key and foreign key etc..?

IBM,

3 7150

what are summary filters? grouped filters?

IBM,

3 7450

How will you display "Mr" for male & "Mrs" for female in target table?

7 13162

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 9085

How will you combine 3 different sources with a single source?

3 8830

how will you get 21 to 30 record from 50 records?

6 12027

how will you remove the duplicate records from flat file without using sorter?

7 19014

How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 9363

Without source how to insert record to target?

6 20073

How to jion 2 tables, without using any condition?

Amazon,

11 38129

How to compare Source and Target table, without using dynamic lookup?

4 11258

In joiner, how to load Master table in Target?

2 7994

Without using Lookup & Sequence Generator, How to generate Sequence?

CTS,

5 14322

Is it possible to have "5 source & 5 Target" in single mapping?

1 6561

How to update records in Target, without using Update Strategy?

3 12163


Un-Answered Questions { Data Warehouse }

How to add default rules in transformer?

1277


how many reports have u created ? explain a few.

2152


Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

2161


Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

2250


faq's on cognos

4108


What is dimensional table?

1145


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.

2797


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

1076


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2814


Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

838


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

1164


What is the difference between business requirement document and use case document.

1073


EXL informatica Questions

1451


Write the unconnected lookup syntax?

1139


what are the names of the reports that you prepared?

1185