How to get top five rows in datastage?
How to get top five rows in datastage? I tried to use @inrownum,@outrownum system variables in transformer..But they are not giving unique sequential numbers for every row...Please help! thanks in advance!!
What is host name in datastage?
nothing but server name
Is it possible to use server components in a parallel job? If yes, how?
How to remove leading zeros in data and transform data to target?
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.
How to see the data in the dataset in UNIX. What command we have to use to see the data in dataset in UNIX?
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
Diff between userdefined environment variables and parameter sets
Hi all, pls let me know the purpose of using user defined environment variables and parameters sets
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...
Purpose of using user defined environment variables and parameter sets
What is the purpose of using user defined environment variables and parameter sets. I m little bit confused. Could any one explain me in detail.?
Transformer order of execution
What is the order of execution in the transformer?
what is
1.Stage variables
2.Constraints
3.Derivations
Order of execution
1. Stage variable
2. Constraints
3. Derivations
How to use excel file as input in datastage??
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
Src has 1 record I want 10records in target how is it possible ? Plz explain me ?
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
How to recompile the job automatically when the job failed to compile?
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.
How to get the reject records from join stage?
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
Transformer stage compilation error in ascential datastage 7.5, windows XP
Hi, i have installed the datastage 7.5 in XP operating system, also installed visual studio .Net 2008 for C++ compiler. But when trying to compile the datastage job which contain the transformer stage, I am unable to compile. below warning I am getting: warning: the pwd environment variable is not...
Where do you specify nodes for datastage jobs?
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
How to connect from client machine to UNIX server in datastage?
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...
What is the difference between a filter and a switch stage ?
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.
How to extract your flat files using sequntial file or dataset? From where to get these flat files as source?
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.
What is meant by lookup stage?
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 !
What is data granularity? Explain.
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...
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...