Data Stage Interview Questions
Questions Answers Views Company eMail

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

CTS,

7 21453

how to define satge variables in transformer stage

2 21045

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

TCS,

3 9055

How to display errors in datastage?

TCS,

1 3159

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

TCS,

5 11982

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 5247

What is the difference between SQl Loader and OCI in datastage?

CSC,

2 13326

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

CSC,

4 14105

How to use Environment variable's in datastage?(use of process)

CSC,

1 6789

what is the use of surogate key in datastage

TCS,

1801

hi this is kiran i have one table i want divide the table with two different table like even rows and odd rows how can i do this one tell me plzz

4 7483

what is the use of surogate key in datastage

3 7889

when we have to go for a sequential file stage & for a dataset in datastage?

1 4358

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2064

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

Patni,

9 13649


Post New Data Stage Questions

Un-Answered Questions { Data Stage }

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2413


What are the types of containers?

667


What are the different plug-ins stages used in your projects?

610


What are the primary usages of datastage tool?

610


Differentiate between datastage and informatica?

704






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

2171


Can you explain engine tier in information server?

640


On which interface you will be working as a developer?

624


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

2829


What are the difference types of stages?

610


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1886


Differentiate between odbc and drs stage?

581


How do y read Sequential file from job control?

14369


How do you reject records in a transformer?

615


table actions available in oracle connector?

1078