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

If there is a file that contains 1000 records, I need the ouput to contain these 1000 records with the header as file name concatenated with the current timestamp and trailer as the count of records

TCS,

2 4200

in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh

IBM,

1 3438

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

IBM, YCS,

3 5523

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

Wipro,

4 6684

I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?

 2 5271

A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.

IBM,

3 6433

What is the difference between Link collector and Funnel Stages?

 1 6108

input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

HCL,

1 3816

count number of deptno in a emp table?

IBM,

2 4429

deptno wise to find max and min,and sum of rows and in target to company wise maximum

IBM, TCS,

1 3964

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

Deloitte, IBM,

3 8842

input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

HSBC,

2 5359

what is flow of project?

HSBC, IBM,

1546

explain about citrix scheduling tool in datastage

HSBC,

1797

how to run jon in unix back round process what is command use in runing a job?

HSBC,

2 5225

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

whom do you report?

1492

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

2829

What are the types of views in datastage director?

1234

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

1886

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1454




How to RD using transformer?

848

Give an idea of system variables.

573

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

506

Differentiate between validated and Compiled in the Datastage?

627

What are the different kinds of views available in a datastage director?

589

Is it possible to query a hash file?

1552

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

2171

What is difference between join, merge and lookup stage?

628

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

657

What are the job parameters?

692

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