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

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

TCS,

6 8585

how to handle null values in sequential file?

HCL,

1 16250

how to handle null values using transformer stage?

1 5817

how can u handle null values in transformer stage.

7 21787

What r the existing server jobs in parallalism?

ITC Infotech,

1485

1.what is materialized data? 2.how to view the materialized data?

HCL, IBM,

1984

i have source data like empno,enmae 11 ,aa 12 ,bb i want output like empno,ename 11 ,aa 12 ,bb 11 ,aa 12 ,bb

TCS,

7 8088

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 6502

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 4865

what is the main difference between sorragate key n primary key in one word

2 9015

specify data stage strength?

1 3935

Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari

1918

what is mapping lookup

1 3603

what is the diff b/w switch and filter stage in datastage

Cap Gemini,

2 13254

how to cleansing data

Cap Gemini,

6 12424


Post New Data Stage Questions






Un-Answered Questions { Data Stage }

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 ?

1195


Distinguish between informatica & datastage. Which one would you choose and why?

165


Can we use target hash file as a lookup ?

2344


Why do we use exception activity in Datastage?

217


What are the main features of datastage?

199






What could be a data source system?

203


What is difference between symmetric multiprocessing and massive parallel processing?

187


If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

1213


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

203


Describe the architecture of datastage?

178


Why we use surrogate key?

208


How do you reject records in a transformer?

215


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

2149


To see hidden files in LINIX?

474


Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2266