SAME To more previously staged partitioning to next corresponding stage with same key column values. ENTIRE Can only be used in lookup stage with reference link when it is “normal lookup” In Entire what ever the records that are processing on N1, the same set of records are processed on the rest of the node.
At TekSlate, we offer resources that help you in learning various IT courses. We avail both written material and demo video tutorials. To gain in-depth knowledge and be on par with practical experience, then explore DataStage Training Videos.
RANDOM - Default / Auto Round Robin Generates the next number with sequence Note :- All the Generating stages gives the best performance when they are associated with Round Robin.
column generator , Row generator, Surrogate Key stage RANGE It is an Expensive partitioning Technique than Mod and Hash . This technique needs data pre processing. Note :- Stage :- Write Range Map (Development/ Debug stage) To create the range if we want to use Range partitioning Web Console log in to “IBM information Server” with Same designer ID and PasswordàAdministration users and groups users user open
Reports We can view and generate reports Web console Admin DS AdminProject level Administration (or) Repository level
If we don’t take surrogate key it maintains a new column active flag(indicate current address) o/p:
Ex: After data;(source)
Output Before data(Target)
After Data: (Source)
|CID||CN||Add||A.F||Effective start date||Effective end date|
Active Tag :- (A.F) New records will maintain flag ‘Y’ Old records ‘N’ Tables will data maintain effective start data and effective end data If data is not displayed, then we get a new column record version , unique id
Record version, unique id SCD - Type Table 1 Create table SRC (SNO number (3), S name Varchar 2 (25)); Create the table and reject values Table 2 Create table CIM (SNO number (2), S name Varchar 3 Sname varchar2 (25)); Just create the table only 5 steps for SCD – Type 1
S1:- Select output link as Fact link
S2: Map the lookup key SNO
S3: Source type = flat file
= Source Name = (Empty file Name)
S4 : identifying the purpose of each field
S5: Map required fields to fact table
S1: Set Data set properties S2: Set oracle properties Table name = dim 1 Write method = upset (update and insert) Upset order = update then insert lab :- SCD – 1 Oracle enterprise 0 load dim 1 Oracle enterprise 1 Load src Sno Sname 111 shilpa 222 repeka 333 Archama SCD
Source name = E :/shilpa/scd1.txt empty file
Compile and RUN (b) Data set ----------------------àoracle enterprise à In table (a) , save the columns is Data set 1 and also copy the path of div 1 data set Now, is this job Data setpaste the path is the file columns load (SCD)
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox