1.How do u handle NULL in sequential stage.
2.Difference between switch stage and filter stage.
Answer Posted / xxx
in sequvential file,click on columns tab and click on left
side of column then we can provide null field value.
diff between switch and filter is ,switch is expression
based and filter is condition based
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are routines in datastage?
How a source file is populated?
How to convert RGB Value to Hexadecimal values in datastage?
What is the method of removing duplicates, without the remove duplicate stage?
How a server job can be converted to a parallel job?
What is the difference between orabulk and bcp stages?
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?
What is usage analysis in datastage?
What are some prerequisites for datastage?
Define meta stage?
Is the value of staging variable stored temporarily or permanently?
If you want to use a same piece of code in different jobs, how will you achieve this?
Difference between in process and inter process?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?