Hi all, explain one complex business rule that you had in your
project and how did you accomplish it using DS?
Answer Posted / datastage4you
explain any scenario which you have faced
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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 a merge?
What are iconv and oconv?
Define APT_CONFIG in Datastage?
Is possible to create skid in dim,fact tables?
Why fact table is in normal form?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is the difference between in process and inter process?
Explain how a source file is populated?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
What is active and passive stage?
Whats difference betweeen operational data stage (ods) and data warehouse?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?