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

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 3719

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

IBM,

1 3035

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

IBM, YCS,

3 4998

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 6028

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

2 4630

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 5771

What is the difference between Link collector and Funnel Stages?

1 5431

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 3462

count number of deptno in a emp table?

IBM,

2 4029

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

IBM, TCS,

1 3633

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 8151

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

HSBC,

2 4691

what is flow of project?

HSBC, IBM,

1393

explain about citrix scheduling tool in datastage

HSBC,

1666

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

HSBC,

2 4656


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

Is it possible to query a hash file?

1399


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

868


Describe routines in datastage? Enlist various types of routines.

424


what are the devoleper roles in real time? plz tell i am new to datastage....

1419


There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1610






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

443


What are the types of hashed files in data stage

490


What is the difference between validate and compile?

1562


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

2395


Whats difference betweeen operational data stage (ods) and data warehouse?

472


describe the Steps to confiure a Qlogic switch

1714


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3074


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

445


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

403


In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

432