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

what r the claims? how many type of claims we face from client side?

1 4451

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

TCS,

2 13153

what is the difference between static and dynamic

TCS, Wipro,

4 25787

if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi

IBM, TCS,

17 44332

what is the difference between Cognos EP7 series and Congos8?

Hexaware,

2 10577

How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

Genpact, iFlex, TCS,

7 36176

what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?

Cap Gemini, iFlex,

7 25895

What is the basic relationship between measures and dimensions in transformer modelling

5 9953

in which situations do u go for snowflake schema ?

TCS,

2 8704

in which situations do u go for starflake schema ?

TCS,

6 20131

in which situations do u go for scds ?

TCS,

3 9215

in which situations do u go for sequence generator ?

TCS,

2 9697

how do u get the first record from 50,000 records ?

TCS, UBS,

10 20241

what is incremental loading ?

CTS, IBM, Oracle, TCS,

12 58285

how many tasks are there in informatica ?

DELL, iGate, TCS,

15 51581


Un-Answered Questions { Data Warehouse }

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3446


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

2095


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


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2127


explain in detail about type 3?

1091


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

2176


Have you have ever worked in unix environment and why it is useful in datastage?

1217


what are the data modeling tools you have used?(polaris)

2060


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.

2816


hi i want to learn microstratogy please anyone help to me which institute is best in bangalore any one having related documents ,and video link please mail to this id avanthireddykv@gmail.com

2303


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

1207


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1244


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

2107


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

2095


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2153