1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
Data Stage Interview Questions
Questions Answers Views Company eMail

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

 2 14349

what is initial load and incremental load

ADP,

3 30310

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 11270

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,

2309

what are the errors,warnings in datastage

Syntel, Wipro,

2145

What is Fastly Changing Dimension?

TCS,

6 11842

What is RCP?

TCS,

2 9224

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

IBM,

3 7355

WHAT IS FORCE COMPILE?

FIS, HCL, Polaris,

3 22542

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

IBM,

1801

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 2765

what is factless fact table?

IBM,

3 7025

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 11092

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

Hexaware,

2 34602

how can we create tables in datastage?

 1 12193

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

how to sort two columns in single job in datastage.

2529

explain about citrix scheduling tool in datastage

1808

What can we do with datastage director?

666

What is active and passive stage?

876

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

3376




Where the datastage stored his repository?

616

What is the difference between server job and parallel jobs?

662

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1031

Lookup constraints

838

which r the connectors used in san?

1786

What is the sortmerge collector?

660

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

1649

Can you explain kafka connector?

771

Name the third party tools that can be used in datastage?

611

What is quality stage?

569

For More Un-Answered { Data Stage } Questions Click Here