My Datastage Notes
Pages
(Move to ...)
Home
Different Versions
All Datastage Stages
Configuration File
Sequentional_Stage
Dataset
Transformer Stage
Sort Stage
Aggregator_Stage
Join Stage
Lookup_Stage
Merge_Stage
Filter_Stage
Copy Stage
Funnel_Stage
Column Generator
Surrogate_Key_Stage
SCD
Pivot_Enterprise_Stage
Sequence_Activities
Datastage Study Material/Interview Questions
Datastage Errors and Resolution
Datastage Scenarios and solutions
Unix Shell Scripting
SQL/Database
Datawarehousing Concepts
▼
Thursday, May 23, 2013
Star vs Snowflake Schemas
›
First Answer: My personal opinion is to use the star by default, but if the product you are using for the business community prefers a...
1 comment:
Tuesday, May 14, 2013
Performance Tuning in Datastage
›
1 Staged the data coming from ODBC/OCI/DB2UDB stages or any database on the server using Hash/Sequential files for optimum performan...
2 comments:
ETL Project Life Cycle
›
Business Requirement Collection :- -> The business requirement gathering start by business Analyst, onsite technical lead and ...
1 comment:
Saturday, May 11, 2013
Change Capture Stage(CCD)
›
CDC -- Change Capture Sample Source Data You can take like below Before_Data e_id,e_name,e_Add 11,kim,bris 22,jim,mel 33,pi...
Tuesday, May 7, 2013
Generating a sequence number in datastage
›
surrogate-key-generation in Transformer Create a unique counter in datastage This entry describes various ways of creating a unique ...
1 comment:
‹
›
Home
View web version