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 / 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 |
WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD
How the ipc stage work?
What are the steps needed to create a simple basic datastage job?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
Differentiate between hash file and sequential file?
i having source like emptable,dept table and combined purpose using for the join stage but join stage which partition techq will be prefored? pls given the ans?
SOURCE CITY NAME1 NAME2 NAME3 NAME4 BGLR HCL CSC IBM TCS TARGET CITY COMPANY BGLR HCL BGLR CSC BGLR IBM BGLR TCS
what is snow flack schema?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
What are iconv and oconv?
What is the sortmerge collector?