-
Flat File Header and Footer
Does flatfile contain header & footer?How to remove Header & Footer from a flatfile before extracting the data?What information header & footer contains?
nikhilanshuman
- Nov 30th, 2010
Does flatfile contain header & footer? =>Yes, it may or may not contain header or footer depending on the requirements. How to remove Header & Footer from a flatfile before extracting t...
Brajesh Singh Bhadoriya
- Sep 20th, 2010
A Flat file can have header and trailor. These will contain the information about the file. For example, header will have date for which the file is, and trailor will have records count. this count ma...
-
Host name specified is not valid, or the host is not responding
I downloaded data stage at my home pc. when iam trying to open data stage administrator datastage designer or datastage director it showing me an error like "host name specified is not valid, or the host is not responding(81011). could any body can help me out how can i get host name, user name and password, because i didn't mention any host name, username or password while installing the software.
nikhilanshuman
- Nov 30th, 2010
In the server name, specify "127.0.0.1". This is the address of your machine. When the user id and password is asked, there is a checkbox to Omit the userid and password. Mark that checkbox. After ...
-
Datastage versions difference
What is the difference between datastage 7.1 & 8.0.1 versions ?
shyam.kandi99
- Nov 9th, 2010
Diff B/W Data Stage version 7.5 and Version 8.0I ) in 7.5 >> 4 client components in 8.0 5Client ComponentsDS Designer Web ConsoleDS Director Information AnalyzerDS Manager DS DesignerDS Administ...
-
We have to choose between Datastage and Informatica.Which of these is better?Our DW is approx. 3-5 GBEnvironment is NT.We have INFA 7.2 and the business we just took over has Datastage 7.5. Here's one side of the story:A customer that recently migrated from Ascential DataStage 7.5 to Informatica PowerCenter 7. The customer has identified that Informatica outperformed Ascential DataStage in the following areas.· Performance - Informatica PowerCenter 2.5x faster than DataStage 7.5· Developer Productivity – · Informatica was 6-times more productive (It took 6 DataStage mappings compared to 1 Informatica mapping).· Informatica mappings required no custom coding. Ascential DataStage required 20% custom coding.· Vendor Independence - Datastage underlying engine is replaced by DB2. Customer has to upgrade for future support and upgrades requires the customer to pay for services. Customer is Oracle/SQL Server shop with no DB2 expertise.I would like a suggestion from someone that has worked on both the tools.Thanks,Amar
BethWilson
- Nov 5th, 2010
Interesting comparison. From my experience, and if those numbers are accurate, then there might be a?few other reasons:1. You replaced the worst DataStage developers in the world with reasonable Infor...
handlider
- Oct 14th, 2009
You are much better off using SSIS from Microsoft SQL Server (2005 & 2008)RegardsJP
-
Hi ,in my pc I am unable to login to the Ascential datastage 7.1. whatever the hostname I am specifying... I'm getting the error statement as/...Failed to connect to host: project:UV (The specified hostname is not valid, or the host is not responding(81011)And when I explored the online documentation file....the reason is given as.......follows....When defining a connection to a remote Uni Verse database, a new uvodbc.config entry is added...It's important that the lastline (host=name) is terminated with either a line terminator or space. otherwise the hostname doesnot get picked up correctly by the datastage engine..In this instance the error 81011(bad hostname or host not responding) is reported.can u guide me how to implement the above clue....n overcome my error...Awaiting your reply,Regards,Madhavi.
vydyu4u
- Oct 29th, 2010
Hi guys... even I got the same problem... I worked on it ... at last I got the solution.. but I guess u don't believe...I got the same error...but once.. I have connect to internet for browsing ... an...
-
What is job control?how it is developed?explain with steps?
mcrao1
- Oct 21st, 2010
Control table perform a small verification before running job, Control table will help avoid running query number of times when we are expecting to run single time in a day. Control table contains fields like JOBID,JOB_NAME,PREVIESE_RUN_DATE,
Thank you.
-chalapathirao.m AT hcl DOT comGuest
- Jul 14th, 2006
Controlling Datstage jobs through some other Datastage jobs. Ex: Consider two Jobs XXX and YYY. The Job YYY can be executed from Job XXX by using Datastage macros in Routines.To Execute one job from o...
-
Convert Date in Modify Stage
How to convert date format from dd/mm/yyyy to yyyy/mm/dd in modify stage?
Brajesh Singh Bhadoriya
- Sep 25th, 2010
To convert date from DD/MM/YYYY to YYYY/MM/DD, first we have to change the default date format in the job. Follow below steps:1. Go to job property. Go to Defaults tab. There un-check the option for d...
-
Sequential File Stage Duplicates
How to remove duplicates through only sequential file stage?
Brajesh Singh Bhadoriya
- Sep 25th, 2010
To remove duplicates from a sequential file, use filter property of sequential file stage. Put "sort | uniq" in filter and it will remove duplicates from file and in output it will have all unique records.Hope this helps.
-
What are the different type of links in datastage.
pavan
- Aug 31st, 2006
Two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------>
-
Convert Column into Rows
How to convert columns into rows without using Pivot node?
captainvenu
- Sep 11th, 2010
Pivot is not a node ok. and as per my knowledge without pivot we unable to convert columns in to rows
-
Data Stage Language
What is the Language of Data Stage?
-
Calculation Without using Aggregator
How to calculate Sum, Averages, Minimum, Maximum salaries of an employee without using Aggregator stage in datastage?
-
Job Unlock
How to unlock a locked job in Datastage 8.0?
vharids
- Sep 3rd, 2010
We can unlock the jobs by using 'cleanup resources' optionin DS director-->tools->cleanup resources
-
Data Validations
What various validations do you perform on the data after extraction?
varunndschange
- Aug 13th, 2010
In data validation we check for the data size, data type, removing extra spaces and applying proper null handling.
veer.dwh
- Aug 13th, 2010
It depends upon the requirment you needed.Some bascic checks:1. NULL validation2. Data type validationif you consider Data quality below points may come across1. Address fileld validations2. Word validations3. Character validations
-
Target Size
What is the normal size of data warehouse in a project?
-
Dataset Parallel Jobs Performance
Will the performance improve by using dataset in parallel jobs? How?
tisha24
- Aug 5th, 2010
Yes. Since the datasets are internal storage file format for datastage and build using orchestrate scripts,the specific scripts for datastage. So the dataset can be processed with out any transcoding and hence very faster.
-
Aggregator Stage Hash Partition
How will the performance improve by using Hash partition in Aggregator stage?
tisha24
- Aug 4th, 2010
As we know,In HASH partition, data with same key column/columns are moved to one partition for processing.aggregation is done with grouping on key column. So with Hash partio...
-
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
-
Data Vaidations
What various validations do you perform on the data after extraction?
-
Please list out the versions of datastage Parallel , server editions and in which year they are realised.
srilaja
- May 19th, 2010
About DataStage Product- DataStage was conceived at company called VMark that developed two notable products: UniVerse database and the DataStage ETL tool in first half of 1996.- VMark acquired UniDat...
DataStage Interview Questions
Ans