Follow Our FB Page << >> 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?


6 8585

how to handle null values in sequential file?


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,


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



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


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


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 ?


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


Can we use target hash file as a lookup ?


Why do we use exception activity in Datastage?


What are the main features of datastage?


What could be a data source system?


What is difference between symmetric multiprocessing and massive parallel processing?


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


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


Describe the architecture of datastage?


Why we use surrogate key?


How do you reject records in a transformer?


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


To see hidden files in LINIX?


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