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

Hi This is Vijay, How can your remove the duplicates in sequential File?

HCL, Scope International,

15 21350

Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?

Semantic Space,

8 8644

How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?

1 10041

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

TCS,

5 8510

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

CTS,

6 12133

What's the Main Function of the Staging area in DWH

Oracle,

3 11404

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

Scope International,

15 23582

in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?

IBM,

1591

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

IBM,

1 6709

what is advantages of snowflake when it is used?

IBM,

3 5608

Hi Vijay here For Four CPU's how many nodes will required?

TCS,

4 7639

wt is the difference between swith and filter stage

IBM,

6 14592

In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.

IBM,

1 10310

in aggregator , how can i get the sum in readable format

IBM,

4 6794

what r the stages mostly used in realtime scenarios

HCL, IBM,

4 20678


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

How many types of views are there in a datastage director?

167


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

529


What are the difference types of stages?

167


Name the third party tools that can be used in datastage?

156


What is the difference between Datastage 7.5 and 7.0?

188






What are some prerequisites for datastage?

133


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

148


What is the purpose of interprocessor stage in server jobs?

1289


What are the steps needed to create a simple basic datastage job?

161


How can we improve performance of data stage jobs?

150


Difference between data warehousing and olap?

169


What is meta stage?

146


Define Routines and their types?

176


HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?

3527


what is the use of skid in reporting?

1472