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 we take 2 tables(like emp and dept), we use join stage and how to improve the performance?

Cap Gemini,

5 10659

how to create document in datastage?

Cap Gemini,

1 4651

how to transfer file from one system to another system in unix? which cmd to be use?

Cap Gemini,

5 11078

when u face critical situation in ur project, how to solve them?

Toyota,

1 8508

explain unit testing,systemtesting,integrated testing

CSC,

1 5388

how many stages are there in Datastage... Please clarify mee??

3 5968

what is the best stage in datastage parller jobs to use full out join and why

Virtusa,

5 11702

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

Virtusa,

3 10138

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1238

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

Wipro,

10 10662

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 6518

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

CTS, IBM,

3 18776

how can we create a Sorrogate key in transformer stage? I want it in parallel mode

Syntel,

2 10175

How to remove duplicates in transformer stage? in parallel mode

Syntel, TCS,

6 12897

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

Syntel,

4 11300


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

what is use of SDR function?

4050


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1531


What are iconv and oconv?

217


How do you remove duplicate values in datastage?

187


whom do you report?

1064






Where do you see different stages in the designer?

193


how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1298


What is difference between server jobs & parallel jobs?

187


Give an idea of system variables.

169


How do you register plug-ins?

202


Differentiate between Join, Merge and Lookup stage?

202


options available in sequence job to run,validate?

455


What is the difference between orabulk and bcp stages?

196


How many Key we can define in remove duplicate stage?

392


Is the value of staging variable stored temporarily or permanently?

162