Data Stage Interview Questions
Questions Answers Views Company eMail

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

UHG,

3941

What is a range lookup?

IBM,

2 7206

what is 'reconsideration error' and how can i respond to this error and how to debug this

Wipro,

2328

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

Wipro,

2 7649

How to display all the duplicate records from the oracle Table?

IBM,

3 9340

how can find maximum salary by using Remove duplicate stage?

IBM,

5 13601

what are the types of nodes

HCL, TCS,

4 24621

how to unlock a locked job in datastage 8.0

HCL,

3 22628

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3428

how to remove duplicates in transformer stage by using stage variables?one example?

Syntel, TCS,

6 32196

IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?

1 5105

how to find out number of records imported into source file?

1 6406

what is a force compile

Cap Gemini, IBM,

2 8529

what is a message handler

IBM,

3 10070

what is the use of invokation id

IBM,

2 10308


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is the difference between informatica and datastage?

876


What are the steps required to kill the job in Datastage?

922


Name the different types of Lookups in Datastage?

970


What is the difference between Datastage 7.5 and 7.0?

854


What is a datastage job?

779


How the ipc stage work?

869


how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

4818


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1818


Which commands are used to import and export the datastage jobs?

1154


Terminate Activity

1033


How rejected rows are managed in datastage?

1165


What is the flow of loading data into fact & dimensional tables?

800


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

1248


What are the functionalities of link partitioner and link collector?

775


Define Routines and their types?

825