-
What are the often used Stages or stages you worked with in your last project?">
What are the often used Stages or stages you worked with in your last project?
A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort.
nikhilanshuman
- Dec 16th, 2010
Transformer,Sequential file stage,sort stage,lookup,join,merge,funnel,filter,oracle enterprise stage,Row generator,column generator,pivot,Dataset stage,aggregrator stage etc.
-
Datastage Parallel Jobs Performance
How will the performance affect if we use more number of Transformer stages in Datastage parallel jobs?
nikhilanshuman
- Dec 9th, 2010
Transformer stages compile in C++ whereas other stages compile into OSH (Orchestarte scripting language.).If number of transfomers are more,first thing is the compilation time will be impacted.it will...
-
Flatfiles Validations
When we are extracting the flatfiles, What are the basic required validations?
nikhilanshuman
- Dec 9th, 2010
Folllowing are some common validations performed:a) Check for blank lines and remove them.b) Check the number of column in each row of the file.c) If there is a? trailer line in the flat file contain...
-
Datastage Lookup
By using lookup we join the data from more than one table, we can implement the same using join stage, then what is the need of Lookup stage especially in Datastage?
nikhilanshuman
- Dec 9th, 2010
Datastage lookup has some additional benefits over join stage :a) A lookup stage supports reject link which is not supported by join stage.b) Lookup stage has an option to fail the job if the lookup f...
-
DataStage Job Scheduling
How to schedule a datastage job using cron tab utility?
nikhilanshuman
- Dec 9th, 2010
The datastage jobs can be scheduled by using following steps:a) Write a script say runjob.sh to call the datastage job/sequence.The shell script calls the datastage job by making use of "dsjob -r...
-
Link sort/Stage sort
What is the use of sort stage when you have explicit sort stage?
nikhilanshuman
- Dec 9th, 2010
Link Sort and stage sort,both do the same thing.Only the Sort Stage provides you with more options like the amount of memory to be used,remove duplicates,sort in Ascending or descending order,Create change key columns and etc.These options will not be available to you while using Link Sort.
praveen.sarva
- Dec 1st, 2010
Simple... For huge amount of data we prefer link sorting... Under partitions for small and compatable data we use stage sort(nothing but sort with in data set).
-
Nodes Types
What are the types of nodes in datastage?
nikhilanshuman
- Dec 9th, 2010
The degree of parallellism of parallel jobs depends on the number of nodes you define in your configuration file.Nodes are just the logically created processes by the OS.basically two types of nodes e...
-
How to use database performance tuning and also ds job performance in datastage.
nikhilanshuman
- Nov 30th, 2010
Database performance tunings:Whenever you are firing queries on source databases containing joins, make sure that proper indexes are created for optimizing query performance.Try to partition the tab...
-
What is surrogate key? what is routine and explain the use in datastage parallel server jobs?
nikhilanshuman
- Nov 30th, 2010
A surrogate key is none business key. it can be a sequential number with no business meanings. these are useful for the underlying applications to maintain relationships between tables.Routines are th...
pavan.daddanalla
- Apr 14th, 2008
Surrogate key is a separate key column which is generated by surrogate key generator. routines are nothing but subset of functions
-
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?
DataStage Interview Questions
Ans