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 5395

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 5891

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

TCS,

1 4198

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

TCS,

3 12933

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 7809

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

TCS,

6 10108

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 12489

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 11144

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

TIAA CREF,

3 15636

How to find value from a column in a dataset?

TIAA CREF,

1759

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

TIAA CREF,

2 6538

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 6687

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

TIAA CREF,

1 6614

what is operator combinality in datastage?

TCS,

1 6778

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 5976

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2263

Notification Activity

888

What is ibm datastage?

595

How to reverse the string using unix?

2787

State the difference between an operational datastage and a data warehouse?

598




I have a few records just I want to store data in to targets cycling way how?

1886

How to perform incremental load in datastage?

655

Differentiate between hash file and sequential file?

571

Where the datastage stored his repository?

607

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

3752

What is orabulk stage?

619

how to implement scd2 in datastage 7.5 with lookup stage

5117

What are stage variables and constants?

692

How do you generate sequence number in datastage?

617

What is the importance of the exception activity in datastage?

614

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