Can anybody tell me in detail any complex datastage job? I
have worked only in direct load and full refresh jobs.But in
all interviews this question arises
Answer Posted / lakshmi
Working up with fact jobs is a complex one as to gather the source from multiple dimensions in to one dataset, while gathering it may endup with joining many lookups and db connectors.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Define oconv () and iconv () functions in datastage?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How do u convert the columns to rows in datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
What are the steps needed to create a simple basic datastage job?
Name the different types of Lookups in Datastage?
What is process model?
Where the datastage stored his repository?
What is the difference between operational data stage (ods) and data warehouse?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
What is the sortmerge collector?
Differentiate between Join, Merge and Lookup stage?
Highlight the main features of datastage?
How do you import and export the datastage jobs?
What is the difference between passive stage and active stage?