-
Load 1 input column values (with delemeter) into different target columns
I have column X which having 3 values A;B;C. How can I load these values into 3 diff cols in the target. If tomorrow I will receive 100 values for same single column I will load into 100 target cols respectively (Same de-limiter) ?
-
What r XML files and how do you read data from XML files and what stage to be used?
-
How do you remove duplicate records from a file and capture the rejected records in a separate file.
nagoosk
- May 29th, 2008
sort the records using the key field.In sort stage put "key change column = true".Then zero will be assigned to the duplicate records.then put a condition as which is record is zero then send it to reject link
nagoosk
- Jan 17th, 2008
we can remove duplicate records by specifying the one of the column in target stage as key column
-
Dimensional modelling is again sub divided into 2 types.
a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form.
cyberdiptikanta
- Jun 26th, 2010
Star Schema is performance wise better than Snow Flake Schema. As Star schema uses denormalise tables, so there will be less no of join as compared to Snow flake Schema.RegardsDiptikanta
shady2pac
- Oct 19th, 2008
Is not star schema better performance wise (querying) as it has less no of join due to denormalized structure? Please clarify
-
How I can convert Server Jobs into Parallel Jobs?
veer.dwh
- Oct 1st, 2009
Hi,I have worked on server to px migration project. you can't directly convert a server job to PX job. the only way is, you have to redevelop the px job using px environment.Regards,Veeru.
Abhijain
- Feb 20th, 2008
On a job level- to convert server jobs into a parellel job is not possible.The mechnism of server jobs is different then that of parellel jobs.You have to re-build the job.
-
Types of Parallel Processing?
Parallel Processing is broadly classified into 2 types. a) SMP - Symmetrical Multi Processing. b) MPP - Massive Parallel Processing.
-
How do you populate source files?
tisha24
- Dec 29th, 2008
If this question means creating dummy records for parallel jobs, then 1. need to load the proper metadata to the row generator stage 2. and then supply the criteria and conditions like how the data sh...
ETLSafari
- Oct 23rd, 2008
In DW concept, the source file is the one provided by the user or OLTP system and is extracted by scripts, feed in to ETL system for processing. So, it is to be taken as input and to output/populate.
-
How do you merge two files in DS?">
How do you merge two files in DS?
Either used Copy command as a Before-job subroutine if the metadata of the 2 files are same or created a job to concatenate the 2 files into one if the metadata is different.
gagan8877
- May 8th, 2007
Use the merge plug-in stage which can merge two files based on the defined key fields by using, INNER or OUTER joins, UNION, Intersection or Minus operations.
hanug
- May 7th, 2007
We can use either FUNNEL stage or use the sequentil stage and read more then one file(both files format should be same). Hanu.
-
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
DataStage Interview Questions
Read Best Answer
Ans