What is the flow of loading data into fact & dimensional tables?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between passive stage and active stage?
I have a few records all are same structures data, I want to store data in multiple targets how?
what is meta data? Explain? Where it is used?
What is the differentiate between data file and descriptor file?
Differentiate between operational datastage (ods) and data warehouse?
What is Fastly Changing Dimension?
plz tell me some dimentional and fact table names in banking project?
how to implement scd2 in datastage 7.5 with lookup stage
root tree will find which is server job and which is parallel job?
diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?
This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)
EXPLAIN SCD