-
What is Metastage?
Read Best Answer
Editorial / Best Answer
spartankiya- Member Since Feb-2007 | Feb 19th, 2007
MetaStage is a persistent metadata Directory that uniquely synchronizes metadata across multiple separate silos, eliminating re keying and the manual establishment of cross-tool relationships. Based on patented technology, it provides seamless cross-tool integration throughout the entire Business Intelligence and data integration life cycle and tool sets
spartankiya
- Feb 19th, 2007
MetaStage is a persistent metadata Directory that uniquely synchronizes metadata across multiple separate silos, eliminating re keying and the manual establishment of cross-tool relationships. Based o...
-
OCI has fetched truncated data" in DataStage">
How do you fix the error "OCI has fetched truncated data" in DataStage
qwert123
- Jun 29th, 2009
The truncation occurs when data type in database(say Oracle) is of type decimal (10,6). But in data stage it's data type is decimal (10,2)). So we need to increase the precision value in the data stage.
AjaysKumar
- Jun 4th, 2008
This error occurs when Oracle Stage try to fetch a column like 34.55676776... and actually it's data type is decimal(10,2)The solution here is to either truncate or Round the data till 2 decimal positions
-
-
How to implement type2 slowly changing dimenstion in datastage? give me with example?
Amritendra kumar
- Feb 22nd, 2008
Shiva is right and he suggested with a great example. You can perform this logic by taking transformer and hashfile stage in server job and if you want to perform scd in parellel then you will have to use change capture and change apply stage.
manoharkolukula
- Feb 12th, 2008
Hello ,He is asking about implementation of type2 in ds, u r telling about type1,type2, type3 history, everybody know what are those things. if u know then tell otherewise leave it.1. we have to use s...
-
What is quality stage and profile stage?
vasanthsolai
- Apr 14th, 2008
Quality stage is used for check the quality..profle stage is used to anaylse the data and their relationship
Abhijain
- Feb 20th, 2008
Quality stage is a data integration tool from ascential which is used to stadardize/integrate the data from different sources.
-
How to eleminate duplicate rows in data stage?
natashajain21
- Sep 22nd, 2009
Some of the methods to remove duplicates -> 1. Remove Duplicate Stages2. Hash File3. In Sort stage there are 3 ways -> a. Set CHANGECAPTURE Property to True . you ha...
ravi
- Dec 11th, 2006
There are two methods for eleminating duplicate rows in datastage1. Using hash file stage (Specify the keys and check the unique checkbox, Unique Key is not allowed duplicate values)2. Using Sort stage by link remove duplicate stageThanx
-
-
What are two types of hash files??
prashant narayani
- Dec 27th, 2006
The two type of hash file are, 1) static and 2) dynamic,,,,, the dynamic hash file is again subdivided in to Generic and Specific
Goutham
- Dec 19th, 2006
The most commonly used hash File is type 32 Dynamic hash files and we use hash files in server jobs...
-
Is Hashed file an Active or Passive Stage? When will be it useful?
vasanthsolai
- Apr 17th, 2008
Hash file is passive stage,it wil be used in lookup,the hash file using hahing algorithm and reterive the data faster...
wahi80
- Feb 20th, 2008
Has files is a passive stage. In DS Server edition hash files are used in jobs where lookups are required. Hash files are generally used in intermediate jobs in DS, where there is a need tostore data in anintermediate table format
-
How to connect from client machine to Unix server in Datastage?
vjviji86
- Jan 30th, 2012
I work on Datastage 8.1 ...Most of the Clients framework prefers Connect DirectProtocol when compared to SFTP?
nikhilanshuman
- Mar 17th, 2010
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...
-
Datastage Questions
what is multiple instances?how u trigger the job in windows?how can u see,delete dataset in unix and windows?what is the function of shared container?why don't we use odd nodes to run the job?what is the normal view and materialized view?when do u use separate sort stage and inbuilt sort utility in a stage?what is the difference?if a job is aborted?can v run the job with out compilation?how do u commit...
j.padma89
- Jul 16th, 2011
How to check the no. of nodes while running the job in UNIX? Answer : type in the directory path where the apt_config_file is located,then u can see the no of nodes and other config information like ...
j.padma89
- Jul 16th, 2011
If a job is aborted?can we run the job with out compilation
Answer:For any condition ("abort " or "reject"), one should run a job only after compilation (strictly) -
Datastage Lookups
Please let me know how many lookups is there in Parallel Jobs.
veer.dwh
- Sep 19th, 2009
In DS 7.5 we have 2 types of lookup options are avilable: 1. Normal 2. SparceIn DS 8.0.1 we have 3 types of lookup options are available 1. Normal 2. Sparce 3. RangeRange lookup: this will help you to...
Amritendra kumar
- Feb 21st, 2008
By lookup stage we can perform lookup by 2 ways1. lookup: It is used when the reference table or file contain less data.2. Sparce lookup: It is used when the main table is small and reference table is big.Thanks
-
Debug stages in PX
What are the different Debug stages available in Datastage PX?
Amritendra kumar
- Feb 22nd, 2008
Head, tail, rowgenerator,columngenerator,peek,sample, write range map .
-
Dataset in UNIX
How to see the data in the Dataset in UNIX. What command we have to use to see the data in Dataset in UNIX?
-
How do you remove duplicates in dataset
in how many ways we can delete dataset? If a record is duplicated 3 times then how to get middle duplicated record? Is it advisable to use basic Tfr in Parallel jobs?
chhavis928
- Oct 9th, 2011
We can use filter stage here to get middle record from 3 duplicate records.
srkreddy111
- Aug 12th, 2011
First you have to open the data set and click on the partitioning and after click hash partition and next click perform sort after click on unique and after ok and after compile and run the job.open the target output,the duplicate records are removed..
-
Fetching last row from a particular column of sequential file
how to fetch the last row from a particular column.. Input file may be sequential file...
Mallikarjuna_G
- Aug 10th, 2013
There are multiple ways to do this, given that input is a sequential file. Two of them are
1. Use "Filter" option available in Seq file stage. Specify a unix command like: tail -1 (recommended)
2. Use a tail stage next to Seq filestage and then specify.Akil
- Apr 1st, 2013
There are 2 ways to fetch the last row of any file if the number of records in the file is not known before run time:
1) Use the tail stage and run the tail stage in sequential mode
2) Use the lastrow() function in the transformer stage -
Shell scripts in sequencers
How you will call shell scripts in sequencers in datastage
nikhilanshuman
- Dec 25th, 2009
Tina-Shell scripts can be called from the execute command activity of a job sequence.
nikhilanshuman
- Dec 11th, 2009
"Execute command activity " is used to run a command from Unix.bash /path of script/scriptname.sh is also a unix command.hence it can also be called from Execute command activity of a job sequence.
-
Downstream & Upstream
What are these terms used for in Datastage - Downstream and Upstream?
-
Lookup Stage Partitioning
With a Lookup stage the input stage has 1million records and reference link has 1million records. What is the best Partition method and why?
Kumar Shourav
- Oct 24th, 2009
Better to use JOIN or MERGE stage in place of Lookup. If input data is low in compare to reference data then Lookup is recommendable. Assumption is 1:100 or more.
gopalanrr
- Mar 27th, 2009
When the reference link is too high in terms of records fetched, you should be performing a join instead of performing a lookup
-
DataStage Interview Questions
Read Best Answer
Ans