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 to use Environment variable's in datastage?(use of process)

CSC,

1 7824

Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.

5 7394

what is the difference between Ranking and sort-out in bo?

iNautix, TCS,

2 15068

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

TCS,

1 2351

what are the different ways of merging two datasets.name atleast 4.

2 6204

How many types of models are present in cognos.?

4 11348

what is the use of surogate key in datastage

TCS,

1 2397

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 9184

what is the use of surogate key in datastage

3 9647

Plz can any one say me how to get the informatica certification materials and dumps

TCS,

1 2121

why normalizer transformation can not used in mapplet? plzzzz answer

Syntel,

2 15331

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

IBM,

2 7104

what is stitched query???

IBM,

2 6484

what is Galaxy schema??

IBM, iGate, Wipro,

2 8966

when we have to go for a sequential file stage & for a dataset in datastage?

1 5230


Un-Answered Questions { Data Warehouse }

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

848


how many reports have u created ? explain a few.

2162


What is the purpose of Dataware Control?

1121


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2084


Are you involved in writing the inferential analysis plan? Tables specifications?

4019


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

2095


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


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2438


hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com

1998


what is document design in boxi,have u participate in that

2308


What is dimensional table? Explain the different dimensions.

1272


Hi, If anyone has base SAS certification dumps, please share.

1941


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1212


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6079


faq's on cognos

4114