Answer Posted / niti
data should be hash partitioned & sorted.. :)
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the difference types of stages?
How do you import and export the datastage jobs?
What is the difference between operational data stage (ods) and data warehouse?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
What is the process of killing a job in datastage?
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 "fatal error/rdbms code 3996" error?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
what is the use of skid in reporting?
Explain entity, attribute and relationship in datastage?
What are the partitioning techniques available in link partitioner?
How to convert RGB Value to Hexadecimal values in datastage?
How do you generate sequence number in datastage?
What is the purpose of pivot stage?