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
What is the command line function to import and export the ds jobs?
Describe the architecture of datastage?
Name the different sorting methods in datastage.
why do u need the IOS upgradation in a FC switch
What is datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
If you want to use the same piece of code in different jobs, how will you achieve it?
Explain datastage architecture?
How to reverse the string using unix?
Why we use surrogate key?
How many areas for files does datastage have?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
Define orabulk and bcp stages?
Where the datastage stored his repository?
Where do you see different stages in the designer?