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 is PX?

IBM,

2 7312

what is time dimension? and how to populate time demension

TCS,

2 11873

How do you load dimension data and fact data? Which is first

2 15536

what is initial load and incremental load

ADP,

3 32132

what are the row and column separations in Flat Files

CTS,

3 8755

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1 1973

What is the difference between Generate Records Component and Create Data Component?

Steria,

6 27704

sample mappings for scd1,scd2 and scd3

Cognizant,

2 20939

Hi friends please reply what will be the answer to following question in crystal report 1)Difference between the CR8.5 & CR10.5(withing VS2008) in terms of features. 2)Is Hierarchy of grouping features in either CR8.5 or CR10.5. what are its limitation i.e maximum no's can be created. 3)Scenario - If I have a string semicolon separated(1000 in nos) then how to pass it into Record Selection formula or parameter. 4)Scenario - If user want to do dynamic grouping at runtime that to while designing report only 1 group was created and as per user at runtime based on user selection different fields are used to create group. How is it possible. (Is it possible through formula?) 5)what is cascade or dynamic prompting.whether this is a feature of CR8.5 or CR10.5. 6)what to answer for question "How would you start crystal report development" 7)How "set location" is useful & how to implement it. 8)Scenario - At design time report was developed using MS SQL as datasource but at client side they are using Oracle which is having same table name and structure will the report work? If yes what changes are required to do so. 9)when does "Table Not Found" error is generated.

1 2261

Tell different ways to create Macrovarible?

Accenture, PharmaNet i3,

3 8891

In how many ways we can apply the security to a cube in Transformer? Explain?

Wipro,

1 5480

i/p o/p1 o/p2 1 1 4 1 1 5 1 1 6 2 2 2 2 2 2 3 3 4 5 6 how to populates i/p rows into o/p1&o/p2 using datastage stages?and also the same scenario using sql?

IBM,

8 14117

Can we specify checkpoints without Phases?

IBM, Tech Mahindra,

3 16385

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

Patni,

5 12511

Can you read multiple input files using one input file component ?(same DML)

IBM,

4 19761


Un-Answered Questions { Data Warehouse }

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2069


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1673


What sort of existing documents should business analysts refer to when starting on a new project?

1078


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

2095


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

1122


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 ?

2086


what are the names of the reports that you prepared?

1203


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

3668


explain in detail about type 3?

1093


Explain in detail about scd type 1 through mapping.

1648


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

1044


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2346


What is a rollup component? Explain about it.

1246


How to add default rules in transformer?

1288


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

1237