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

what is materialized view used datastage?

HSBC,

1 4869

which dim, fact tables used in bank domain

HSBC, IBM,

1 6502

which unix commands mostly used in datastage

HSBC,

3 7370

In one project how many shared containers are created?

NTT Data,

3 5168

How will you move hashed file from one location to another location?

NTT Data,

1641

whom do you report?

NTT Data,

1494

Is possible to create skid in dim,fact tables?

NTT Data,

2177

what is the use of skid in reporting?

NTT Data,

1943

client know skid info?

NTT Data,

1625

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

 2012

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

Polaris,

1 2747

how to load meta data

IBM,

2 3433

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

CTS,

2 8528

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

Wipro,

4 6748

Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.

iGate, Thirdware,

4 6687

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1738

What is aggtorec restructure operator?

709

What is the method of removing duplicates, without the remove duplicate stage?

573

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

1655

What is the difference between orabulk and bcp stages?

562




What are the primary usages of datastage tool?

612

What are the main features of datastage?

653

What is the difference between an operational datastage and a data warehouse?

621

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1771

Define oconv () and iconv () functions in datastage?

864

What are the types of containers and how to create them?

546

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

612

Define repository tables in datastage?

691

Differentiate between hash file and sequential file?

569

Where the datastage stored his repository?

605

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