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 Stage Interview Questions
Questions Answers Views Company eMail

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

2 15413

what is initial load and incremental load

ADP,

3 31919

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 13791

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)

Polaris,

2733

what are the errors,warnings in datastage

Syntel, Wipro,

2706

What is Fastly Changing Dimension?

TCS,

6 14014

What is RCP?

TCS,

2 10906

what are fact tables and dimension tables? give example assuming one table.

IBM,

3 8635

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 24274

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

IBM,

2279

Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

IBM,

1 3528

what is factless fact table?

IBM,

3 8520

explain how to create SCD-2 IN DATASTAGE 7.5X2 PLZ EXPLAIN WITH 4 OR 5 RECORDS TAKE IT EXAMPLE AND JOB DESINGN URGENT

IBM, Polaris,

3 12566

how to identifie,is it innerjoin,leftouter join in lookup?

Hexaware,

2 36191

how can we create tables in datastage?

1 12931


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How you Implemented SCD Type 1 & Type 2 in your project?

4137


Explain the situation where you have applied SCD in your project?

2045


What is the flow of loading data into fact & dimensional tables?

1069


Can we use target hash file as a lookup ?

3330


How many types of hash files are there?

1185


Differentiate between datastage and datastage tx?

1059


What are the main features of datastage?

1285


Enlist various types of routines in datastage.

1261


What are the primary usages of datastage tool?

1075


What are the partitioning techniques available in link partitioner?

2283


Explain connectivity between datastage with datasources?

987


What is a datastage job?

1019


Explain how a source file is populated?

1373


What are the different options associated with dsjob command?

1449


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)

2733