-
Compare and Contrast ODBC and Plug-In stages?
ODBC : a) Poor Performance. b) Can be used for Variety of Databases. c) Can handle Stored Procedures. Plug-In: a) Good Performance. b) Database specific.(Only one database) c) Cannot handle Stored Procedures.
nikhilanshuman
- Dec 16th, 2010
ODBC stages are slower as compared to Plugin stages.ODBC stages can handle many databases whereas plugin stages are made specially for a particular database for example Oracle enterprize stage.
-
How do you catch bad rows from OCI stage?
gadwalvr
- Jun 25th, 2007
The question itself is a little ambiguous to me. I think the answer to the question might be, we will place some conditions like 'where' inside the OCI stage and the rejected rows can be obtai...
-
Why do you use SQL LOADER or OCI STAGE?
vvk.kotamraju
- Mar 20th, 2006
Data Will transfer very quickly to the Data Warehouse by using SQL Loader.
RamaPrasad Batchu
- Mar 8th, 2006
When the source data is anormous or for bulk data we can use OCI and SQL loader depending upon the source
-
What is project life cycle and how do you implement it?
bakshtheking
- Jun 17th, 2008
Project life cycle is related to SDLCthat is software development life cycle....which mean there are 4 stages involvedthat is 1)Analysis2)development3)Testing4)ImplementationThis covers the entire project life cycle !
-
How will you call external function or subroutine from datastage?
gagan8877
- May 8th, 2007
U can call external functions, subroutines by using Before/After stage/job Subroutines : ExecSHExecDOSor By using Command Stage Plug-In or by calling the routine from external command activity from Job Sequence.
Mujeebur
- Jul 22nd, 2005
There is datastage option to call external programs . execSH
-
How do you do oracle 4 way inner join if there are 4 oracle input files?
hanug
- May 7th, 2007
The Question asked incorrectly.there wont be any Oracle file. It is Oracle table or view object.I never heard about Oracle input file.Can you please explain what your actual question is?Hanu.
-
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.
-
How did you connect to DB2 in your last project?
Read Best Answer
Editorial / Best Answer
gagan8877- Member Since May-2007 | May 8th, 2007
The following stages can connect to DB2 Database:
ODBC
DB2 Plug-in Stage
Dynamic Relational Stagegagan8877
- May 8th, 2007
The following stages can connect to DB2 Database:ODBCDB2 Plug-in StageDynamic Relational Stage
-
How did u connect with DB2 in your last project?
Most of the times the data was sent to us in the form of flat files. The data is dumped and sent to us. In some cases were we need to connect to DB2 for look-ups as an instance then we used ODBC drivers to connect to DB2 (or) DB2-UDB depending the situation and availability. Certainly DB2-UDB is better in terms of performance as you know the native drivers are always better than ODBC drivers. 'iSeries...
Read Best Answer
Editorial / Best Answer
nikhilanshuman- Member Since Nov-2009 | Dec 17th, 2010
By making use of "DB2/UDB Stage".There we basically need to specify connection parameters like client instance name,default server,default database.
nikhilanshuman
- Dec 17th, 2010
By making use of "DB2/UDB Stage".There we basically need to specify connection parameters like client instance name,default server,default database.
-
Read the String functions in DS
Functions like [] -> sub-string function and ':' -> concatenation operatorSyntax: string [ [ start, ] length ]string [ delimiter, instance, repeats ]
nikhilanshuman
- Dec 17th, 2010
It seems that it is being asked to explain string function.Following are some string functions used in datastage:Compare,Field,Convert,Padstring,TrimB,TrimF,TrimLeadingTrailingSome string conversion functions :StringToDate,StringToDecimal,StringToTime,StaringToUstring,StringToTimestamp etc...
-
How would call an external Java function which are not supported by DataStage?
Starting from DS 6.0 we have the ability to call external Java functions using a Java package from Ascential. In this case we can even use the command line to invoke the Java function and write the return values from the Java program (if any) and use that files as a source in DataStage job.
indianarya
- Apr 11th, 2008
Use the Java PACK. Java Pack has Java Client and Java Transformer Stages. YOu can write your own class and call it from either from Client or Transformer stages.
-
What are the command line functions that import and export the DS jobs?
A. dsimport.exe- imports the DataStage components.B. dsexport.exe- exports the DataStage components.
-
The above might rise another question: Why do we have to load the dimensional tables first, then fact tables:
As we load the dimensional tables the keys (primary) are generated and these keys (primary) are Foreign keys in Fact tables.
nikhilanshuman
- Dec 17th, 2010
In dimensional model,fact tables are dependenet on the dimension tables.This means that fact table contains foreign keys to dimension tables.This is the reason,dimension tables are loaded first and then the fact table.
-
Tell me one situation from your last project, where you had faced problem and How did u solve it?
A. The jobs in which data is read directly from OCI stages are running extremely slow. I had to stage the data before sending to the transformer to make the jobs run faster.B. The job aborts in the middle of loading some 500,000 rows. Have an option either cleaning/deleting the loaded data and then run the fixed job or run the job again from the row the job has aborted. To make sure the load...
nikhilanshuman
- Dec 18th, 2010
a) We had a big job with around 40 stages.The job was taking too long tocompile and run.We broke the job into 3 smaller jobs.After this ,we observed that the performance was slighly improved and maint...
-
How do you rename all of the jobs to support your new File-naming conventions?
Create a Excel spreadsheet with new and old names. Export the whole project as a dsx. Write a Perl program, which can do a simple rename of the strings looking up the Excel file. Then import the new dsx file probably into a new project for testing. Recompile all jobs. Be cautious that the name of the jobs has also been changed in your job control jobs or Sequencer jobs. So you have to make the...
DatastageDev
- Jun 30th, 2009
If you export the jobs in an XML file you can easily do a find and replace for anything using notepad. So if the standard for master is changed from mst to mstr you simply for a find and replace....
-
-
When should we use ODS?
DWH's are typically read only, batch updated on a scheduleODS's are maintained in more real time, trickle fed constantly
nikhilanshuman
- Dec 19th, 2010
An opearation data store contains the data which are constantly updated through the course of the business operations. ODS is specially designed such that it can quickly perform relatively simply que...
-
Could you please help me with a set of questions on Parallel Extender?
X
-
How many places u can call Routines?
Four Places u can call (i) Transform of routine (A) Date Transformation (B) Upstring Transformation (ii) Transform of the Before & After Subroutines(iii) XML transformation(iv)Web base trannsformation
nikhilanshuman
- Dec 16th, 2010
Routines can be called at the following places:a) In the job properties,There is an option to call the Before and After job subroutines.b) In the job sequence,there is an activity called "Routine...
-
Defaults nodes for datastage parallel Edition
mallakishore
- Oct 20th, 2005
Actually the Number of Nodes depend on the number of processors in your system.If your system is supporting two processors we will get two nodes by default.
sekhar
- Oct 11th, 2005
Default nodes is allways one
DataStage Interview Questions
Read Best Answer
Ans