Answer Posted / sri
Using the Pivot we can convert the columns into rows
| Is This Answer Correct ? | 20 Yes | 2 No |
Post New Answer View All Answers
Which algorithm you used for your hashfile?
What are the different types of lookups in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How many types of hash files are there?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What is the difference between account and directory options ?
describe the Steps to confiure a Qlogic switch
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
Define APT_CONFIG in Datastage?
What are the features of datastage flow designer?
What are routines in datastage? Enlist various types of routines.
Can you explain players in datastage?
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)
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.