1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category
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 10718

how to handle null values in sequential file?

HCL,

1 18567

how to handle null values using transformer stage?

 1 6896

how can u handle null values in transformer stage.

 7 25505

What r the existing server jobs in parallalism?

ITC Infotech,

1982

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

HCL, IBM,

2426

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 10360

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 8302

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 5971

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

 2 10339

specify data stage strength?

 1 4641

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

2350

what is mapping lookup

 1 4536

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

Cap Gemini,

2 15516

how to cleansing data

Cap Gemini,

6 15128

Post New Data Stage Questions

Un-Answered Questions { Data Stage }

What is process model?

1557

How and where you used hash file?

661

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1753

What are stage variables and constants?

707

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

1638




Does datastage support slowly changing dimensions ?

663

What are iconv and oconv?

779

What are the processing stages?

648

Define Data Stage?

647

How to reverse the string using unix?

2816

Which algorithm you used for your hashfile?

695

How to read the length of word in unix?

888

How can we improve performance of data stage jobs?

619

How rejected rows are managed in datastage?

928

Difference between sequential file and data set?

648

For More Un-Answered { Data Stage } Questions Click Here