Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Data Stage Interview Questions
Questions Answers Views Company eMail

What is audit table?

1 4800

How to enter a log in auditing table whenever a job get finished?

L&T,

2 10902

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

Mind Tree,

2 4136

Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?

TCS,

1 3249

what is use of SDR function?

CGI,

4423

what is the use of DSattchJob?DetachJob? where can we find it?

IBM,

1690

root tree will find which is server job and which is parallel job?

IBM,

1295

how can we create rank using datastage?what is the meaning of rank?

IBM,

7937

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

Wipro,

3 7459

is it possible to access the same job by two users at a time in DataStage?

IBM,

2 4632

where the log files or tables can store in DS?

IBM,

2 5063

where we use config file as parameter ?

IBM,

1 4588

job locking methods? How can we unlock the job?

IBM,

3 7292

Is there any possibility to generate alphanumeric surrogate key?

ABC, IBM,

3 9754

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

IBM,

1978


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

How do you import and export the datastage jobs?

544


What is the precedence of stage variables,derivations, and constraints?

447


How many types of sorting methods are available in datastage?

477


What is the difference between operational data stage (ods) and data warehouse?

466


How we can covert server job to a parallel job?

456






What are stage variables, derivations and constants?

505


what is the use of materialized view?

801


What is the difference between validate and compile?

1562


Define ds designer?

506


Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2246


In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

1795


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...

3563


how to abort the job its matain duplicates?

1940


how many rows sorted in sort stage by default in server jobs

3388


How to reverse the string using SQL?

741