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

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

TCS,

1 5390

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

TCS,

2 5885

Display all files which have size more 3KB in given directory/folder.

TCS,

1 4190

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

TCS,

3 12932

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

TCS,

2 7803

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

TCS,

6 10102

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

TCS,

2 12486

I have a input as: Col 1 1 2 2 3 I want 3 output as: Output1: 1 1 Output2: 2 2 Output3: 3 i.e. same duplicates should be in one target, other duplicate values should be in another target and so on.. Pls help

IBM,

9 11137

how can you generate sequence number using only the sequential file stage?

TIAA CREF,

3 15630

How to find value from a column in a dataset?

TIAA CREF,

1757

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

TIAA CREF,

2 6536

You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?

TIAA CREF,

1 6685

How do you load 10 different sources with 10 different layouts to 10 different tables?

TIAA CREF,

1 6613

what is operator combinality in datastage?

TCS,

1 6777

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

IBM,

2 5973

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Can you explain kafka connector?

763

What is the difference between server job and parallel jobs?

656

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

584

How to implement complex jobs in data stage?

603

Is possible to create skid in dim,fact tables?

2175




What are the different type of jobs in datastage?

594

What is the difference between the local container and shared container?

636

What all the types of jobs you developed?

658

Name the different types of Lookups in Datastage?

718

How can we improve the performance in datastage?

636

describe the Steps to confiure a Qlogic switch

1923

How to convert RGB Value to Hexadecimal values in datastage?

3442

Differentiate between hash file and sequential file?

569

How do you schedule or monitoring the job?

650

What is usage analysis in datastage?

800

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