only one fact table and Meany dimension tables
datamarts is subject oriented database

first we need to converted flat files in tables ofter join
the oracle and that table

sdlc(software devlopment life cycle)
This is cycle that show step of how to devloped
application/project.

step of sdlc
1.Meeting with client.
2.Requirement.
3.Analysis/collect information.
4.Coding.
5.Testing.
6.Maintanance & support.

Hai..,

SDLC --- Software Development Life Cycle and Each and Every 
Development Envirnment should be follow SDLC....
Its follow 7 steps
1.Identifies Problem
2.Gathering Information
3.Analysis
4.Design and Coding
5.Quality Assurence (System-Testing)
6.Production
7.Support & Maintanence

kick of meeting
2)analysis of data
3) design
4)unit testing
5)uAT test
6) production
7) maintaince

Hai..,

In sort stage we have one property...its create key change 
column.

In Transformer stage ,we have to write if then else 
condition.....

Yes, Kirans is right

Hash file Give Performance

Hash file is worked in key based . so lookup stage work on
comparasion of columns. so using hash file

1 ) By View Data 

2) By Unix - But the data will be unformatted as dataset 
data is distributed over several nodes.

we can't see data to unix consoles,we can only delete by 
orchadmin command.

We cannot see the data in the Data Set (.ds files) through 
Unix, Editplus etc. But we can view the data by connecting 
a Peek stage to the Data Set stage in a job. Go to Director-
-> job name ---> Peek stage (view .ds file data)

We cannot see the data in the Data Set (.ds files) through 
Unix, Editplus etc. 
1. But we can view the data by connecting a Peek stage to 
the Data Set stage in a job. Go to Director--> job name ---
> Peek stage (view .ds file data) or
2. Connect Sequential File Stage as the target stage to the 
Data Set stage. In the Sequential File Stage-->Input Tab--
>Properties--> Give the Target file path. For Eg: 
(/local/data1/edw/temp/DataSetOp.txt) and run the job. the 
new text file gets loaded with data from the .ds file. Thus 
data will be in a readable format in the text file.

right click on the data set and select by view data option

If we want to see all the data it is :
orchadmin dump <dataset_name>

If we want to see specific field data it is :
orchadmin dump -name -field <field_name> -field 
<field_name> <dataset_name>

But before that the DS environment should be set.
Like below ( but may change based on the configuration): 
export PATH
. /opt/IBM/InformationServer/Server/DSEngine/dsenv

LD_LIBRARY_PATH=$APT_ORCHHOME/lib:$LD_LIBRARY_PATH; export 
LD_LIBRARY_PATH

Use Modify Stage and Drop the columns that are not needed . Or Use a Transformer and take the links tat are only needed(make sure that RCP is not marked )

In the transform stage u select wich coloums u want those
coloums only drage from input link to output link.

Hi,

1. based in reuirement if you need 20 columns, you have to 
select 20 columns in database query.

2. if source is file, use transformer stage and populate 
require 20 columns only

3. if source is database or file you can use copy stage 
insted of transformer and modify.

Using transformation stage
How t o use:
                           Double click transformation stage

	                          Select 20 columns
                                               
                           Drag and drop there target links.

                                    Click on Ok

Using cron command and at command to run multiple jobs at a 
time

ODBC Stage require few connectivites to connect where are 
Oracle just we can connect with server details.

ODBC stage can be used to connect to different databases like Oracle , DB2 ..etc . It can be connected to any databases with ODBC drivers where as ORACLE stage connects only to Oracle databases

If you want to connect to a Oracle database and you are using Oracle stage, it will be faster and better. ODBC stage also does the same but it will be slow and its generic ,, I suggest using ODBC stage where there is no specific plugins to connect to a database.