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, October 17, 2013
Warning : Ignoring duplicate entry at table record no further warnings will be issued for this table
›
This warning is seen when there are multiple records with the same key column is present in the reference table from which lookup is d...
Monday, June 24, 2013
How to replace ^M character in VI editor/sed?
›
^M is DOS line break character which shows up in UNIX files when uploaded from a windows file system in ascii format. To remove this, op...
Thursday, June 6, 2013
How to convert a single row into multiple rows ?
›
Below is a screenshot of our input data City State Name1 Name2 Name3 xy FGH Sam Dean Winchester We are going to read the above data ...
How to perform aggregation using a Transformer
›
Input: Below is the sample data of three students, their marks in two subjects, the corresponding grades and the dates on which they wer...
4 comments:
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:
‹
›
Home
View web version