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

Hi This is Vijay, How can your remove the duplicates in sequential File?

HCL, Scope International,

15 26562

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

Semantic Space,

8 11152

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

 1 11615

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

TCS,

5 10734

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

CTS,

6 15449

What's the Main Function of the Staging area in DWH

Oracle,

3 12888

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

Scope International,

15 29007

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

IBM,

1960

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

IBM,

1 7781

what is advantages of snowflake when it is used?

IBM,

3 7064

Hi Vijay here For Four CPU's how many nodes will required?

TCS,

4 9731

wt is the difference between swith and filter stage

IBM,

6 17189

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

IBM,

1 11328

in aggregator , how can i get the sum in readable format

IBM,

4 8540

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 23430

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Could anyone give brief explanation bout datastage admin

1958

What are the types of hashed files in data stage

630

Notification Activity

884

AGGREGATOR default datatype

919

Why we use surrogate key?

691




What is the purpose of pivot stage?

594

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

1746

Differentiate between Join, Merge and Lookup stage?

630

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

537

What is data partitioning?

735

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

3360

What are the main differences you have observed between 7.x and 8.x version of datastage?

610

How can we improve the performance in datastage?

634

What is the difference between server job and parallel jobs?

652

how to export or import the jobs in .ISX file

702

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