DataStage FAQ

Use stage variables and build a counter like
svCounter + 1 => svCounter
and then you build a condition to your output link svCounter = 5

The answer to this depends on the source from where you are trying to extract. If the source in your case is a file, then we can use "Read first rows" property of Sequential file stage and specify 5...

nothing but server name

TRIM(0,.,A) It will remove 0s all occurance after .

In Transformer stage use DecimalToString() function and in the argument use"suppress Zero". The leading zeros will be suppressed.

The command which must be used is orchadmin dump datasetname(without quotes). But before that run this command "cd `cat/.dshome`dsenv" without quotes. The reason is: cd `cat/.dshome`-> This will cha...

orchadmin rm datasetname

An user defined environment variable is a place holder to store a value that can used in the entire project. Parameter set is new time saving feature added in DataStage 8x. Parameter set is set of jo...

what is

1.Stage variables
2.Constraints
3.Derivations

Order of execution
1. Stage variable
2. Constraints
3. Derivations

The above answer is wrong. Please follow the steps below to load the excel in dataastage :- first open excel sheet and open->saveas-> then save the file as .csv extension while importing u have to s...

I did same as step1, but when i import the metadata it asking username and password, when press ok button it shows NO MATCHES FOUND, pls help me

Thank you
Regards
Srinivas

source-copy stage take ten out links from copy stage-link it to funnel stage-sequential file in this way we can get 10 records in output

I'm interested in this answer because for any reason my jobs appear not compile after I begin the execution and I need an automatic process that auto compile the jobs when it founds uncompiled.

Thanks.

If the job failed to compile, there must be some problem with the job.
If the problem is not fixed then no matter how many times it is recompiled, the compilation will fail each time.
Automatic recompileoption does not seem to be there in datastage.

If you want rejected records also, you need to use an outer join so that all the records are carried forward and then youll need to use next stage as a transformer. In the transformer, you can use appropriate condition in the constraints and redirect the unwanted records to a sequential file.

Outside the join stage, you can put a filter to filter out the records having null values for the columns coming from right part of the join

Node is nothing but an identified by the number of nodes on which parallel jobs can run r not

in app config file which will be named as default.apt

I work on Datastage 8.1 ...Most of the Clients framework prefers Connect DirectProtocol when compared to SFTP?

In Datastage there are the client components like Designer, Manager, Director.When you open these applications, you are asked the user id, password and the Project name to which to want to connect.The...

Both stages functionality and responsibilities is same. But the difference way of execution like.. In filter stage, we have to give the multiple conditions, on multiple columns. But every time data ...

A switch stage can have maximum 128 output links.A filter stage can have any number of output links.

Flat files can be accessed from unix by using sequential file stage. For example if we are having csv file . we can give the path in the sequential stage for this file and we can access the file directly.

Please check your language, it may be the language of your computer did not match your servers language.

Lookup stage is similar as join stage,what ever the records from source to target we can use by using lookup, join and in the lookup we have reject link option and join doesn't have reject link option.

Look up stage is used to join dataset which has similar functionality of join stage with some extras.
the difference between join and look up is here
http://www.geekinterview.com/question_details/82179
Hope it helps !

I am adding one more point to the above answer.Granularity refers to the level of detail of the data stored in any table .
Example :- Year > Month> Week> Day > Hour

In the same manner in real time project also have granularity in the data.

Granularity refers to the level of detail of the data stored fact tables in a data warehouse. High granularity refers to data that is at or near the transaction level. Data that is at the transactio...