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

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

MGL,

2 6833

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

Infotech,

5 8328

How to exclude first and last lines while reading data into a sequential file(having some 1000 records).I guess probably by using unix filter option but not sure which to use

IBM,

6 28835

How to delete the data in dataset?types of deleting the data in dataset?

HSBC,

4 23182

we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?

HSBC, NTT Data,

1 15887

tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

Infotech,

3 7814

i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?

HSBC,

5 10829

Hi All, I have a file. i need to fetch the records between first and last records by using transform stage. EX:- Source: EMPNO EMPNAME 4567 shree 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar 3265 Vishnu Target: EMPNO EMPNAME 6999 Ram 3265 Venkat 2655 Abhi 3665 Vamsi 5852 Amit 3256 Sagar I dont wan't to Shree and vishnu records.we can fetch another way also but How can I write the function in transform stage?

TCS,

2 6242

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

IBM,

1661

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

 2 12976

Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

 2 3204

how to write server Routine coding?

Eric,

1671

What are the prerequisites for join stage

 2 8462

What is the use of surrogate key stage?

 2 5585

Can we use target hash file as a lookup ?

 2820

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is orabulk stage?

639

What are the difference types of stages?

627

Define APT_CONFIG in Datastage?

668

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1760

What is the difference between hashfile and sequential file?

728




Have you used Unstructured data?

841

Enlist various types of routines in datastage.

648

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1145

What are stage variables, derivations and constants?

678

Describe the main features of datastage?

662

What are the components of ascential data stage?

656

What are the processing stages?

648

What could be a data source system?

581

Differentiate between datastage and datastage tx?

601

What are the different layers in the information server architecture?

647

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