data stage faqs

1. Dimension Modelling types along with their significance Subscribe

Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling. Latest Answer: Data Modeling1) E-R Diagrams2) Dimensional modeling 2.a) logical modeling 2.b)Physical mode... Last Updated By RamaPrasad Batchu on December 19, 2005

(Answers: 1) Read / Answer

2. What is the flow of loading data into fact & dimensional tables? Subscribe

Fact table - Table with Collection of Foreign Keys corresponding to the Primary Keys in Dimensional table. Consists of fields with numeric values. Dimension table - Table with Unique Primary Key. Loa Latest Answer: __________________ &nbs... Last Updated By Siraj on August 03, 2007 (Answers: 3) Read / Answer

3. Orchestrate Vs Datastage Parallel Extender? Subscribe

Orchestrate itself is an ETL tool with extensive parallel processing capabilities and running on UNIX platform. Datastage used Orchestrate with Datastage XE (Beta version of 6.0) to incorporate the p

Read / Answer4. Differentiate Primary Key and Partition Key? Subscribe

Primary Key is a combination of unique and not null. It can be a collection of key values called as composite primary key. Partition Key is a just a part of Primary Key. There are several methods of Latest Answer: Hi:Primary key is the key we define on the table column or set of columns(composite pk) to make sure... Last Updated By hanug on May 06, 2007


5. How do you execute datastage job from command line prompt? Subscribe

Using "dsjob" command as follows. dsjob -run -jobstatus projectname jobname Latest Answer: u can use dsjob executable command from unix or command line.The previous post was correct.Hanu.... Last Updated By hanug on May 06, 2007


6. What are Stage Variables, Derivations and Constants? Subscribe

Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the t Latest Answer: Hi Your answer is wrong for order of execution of stage variables, constraints and derivations...the... Last Updated By Sreenubabu P on September 10, 2007


7. What is the default cache size? How do you change the cache size if needed? Subscribe

Default cache size is 256 MB. We can incraese it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. Latest Answer: The default cache size is 128 MB. This is primarily used for hash file data cache in the server. &nb... Last Updated By Balaji on July 12, 2007


8. Containers : Usage and Types? Subscribe

Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a

http://www.geekinterview.com/login.html?ref=http://www.geekinterview.com/Interview-Questions/Data-Warehouse/DataStage

http://www.geekinterview.com/question_details/12392








http://www.geekinterview.com/user-profile/46069

















project. Latest Answer: Container is a collection of stages used for the purpose of Reusability. There are 2 types of Contai... Last Updated By jagan nimmagadda on January 10, 2006


9. Compare and Contrast ODBC and Plug-In stages? Subscribe

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 Pr

Read / Answer10. How to run a Shell Script within the scope of a Data stage job? Subscribe

By using "ExcecSH" command at Before/After job properties. Latest Answer: Hi:Go to Job properties and choose Before or after job routine and choose execute shell.Hanu.... Last Updated By hanug on May 06, 2007


11. Types of Parallel Processing? Subscribe

Parallel Processing is broadly classified into 2 types. a) SMP - Symmetrical Multi Processing. b) MPP - Massive Parallel Processing. Latest Answer: Hardware wise thereÂ areÂ 3 types of parallel processing systems available:1. SMP (symetric multipro... Last Updated By Gary on May 07, 2007


12. What does a Config File in parallel extender consist of? Subscribe

Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location. Latest Answer: Config file was read by datastage engine before running the job in Px.it consist of configuration ab... Last Updated By Sivarao on May 15, 2006


13. Functionality of Link Partitioner and Link Collector? Subscribe

Link Partitioner : It actually splits data into various partitions or data flows using various partition methods . Link Collector : It collects the data coming from partitions, merges it into a singl Latest Answer: server jobs mainly execute the jobs in sequential fashion,the ipc stage as well as link partioner an... Last Updated By jagan nimmagadda on January 10, 2006


14. What is Modulus and Splitting in Dynamic Hashed File? Subscribe

In a Hashed File, the size of the file keeps changing randomly. If the size of the file increases it is called as "Modulus". If the size of the file decreases it is called as "Splitting Latest Answer: The modulus size can be increased by contacting your Unix Admin.... Last Updated By Milestones on September 22, 2005


15. Types of vies in Datastage Director? Subscribe

There are 3 types of views in Datastage Director a) Job View - Dates of Jobs Compiled. b) Log View - Status of Job last run c) Status View - Warning Messages, Event Messages, Program Generated Messag Latest Answer: From what I know there are four views1> StatusÂ 2> Schedule3> Log4> Detail.... Last Updated By satya on July 18, 2007



























16. Differentiate Database data and Data warehouse data? Subscribe

Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current. Latest Answer: Database data is in the form of OLTP and Data warehouse data will be in the form of OLAP. OLTP is fo... Last Updated By bhargava on May 01, 2007


17. What are the difficulties faced in using DataStage ? or what are the constraints in using DataStageWhat are the difficulties faced in using DataStage ? or what are the constraints in using DataStage ?

Subscribe

Read / Answer18. What r XML files and how do you read data from XML files and what stage to be used? Subscribe

Latest Answer: This is how it can be doneDefine the xml file path in the administrator Under environmental paramet... Last Updated By satya on July 18, 2007


19. How do you catch bad rows from OCI stage? Subscribe

Latest Answer: The question itself is a little ambiguous to me. I think the answer to the question might be, we wil... Last Updated By gadwalvr on June 25, 2007


20. Why do you use SQL LOADER or OCI STAGE? Subscribe

Latest Answer: Data Will transfer very quickly to the Data Warehouse by using SQL Loader.... Last Updated By vijay on March 20, 2006 21. Suppose if there are million records did you use OCI? if not then what stage do you prefer?

Subscribe

Latest Answer: using Orabulk... Last Updated By narsimhulu.D on September 11, 2005 (Answers: 1) Read / Answer

22. How do you populate source files? Subscribe

Latest Answer: It seems, the question is not quite right.Can you please explain what do you mean by populate "... Last Updated By hanug on May 06, 2007


23. How do you pass the parameter to the job sequence if the job is running at night? Subscribe

Latest Answer: You can insert the parameter values in a table and read them when the package runs using O... Last Updated By gagan8877 on June 28, 2007


24. What happens if the job fails at night? Subscribe

Latest Answer: U can define a job sequence to send an email using SMTP activity if the job fails. Or log the failur... Last Updated By gagan8877 on May 08, 2007


25. What is SQL tuning? how do you do it ? Subscribe

Latest Answer: sql tunning how to per form thisin sql-server... through query analyser is needed and explain brief ... Last Updated By vinoth kumar on December 18, 2006


26. What is project life cycle and how do you implement it? Subscribe







































Read / Answer27. How do you track performance statistics and enhance it? Subscribe

Latest Answer: You can right click on the server job and select the "view performance statistics" option. This will... Last Updated By satya on July 18, 2007


28. How do you do oracle 4 way inner join if there are 4 oracle input files? Subscribe

Latest Answer: The Question asked incorrectly.there wont be any Oracle file. It is Oracle table or view object.I ne... Last Updated By hanug on May 06, 2007


29. What is the order of execution done internally in the transformer with the stage editor having inpuWhat is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links?

Subscribe

Read / Answer30. Explain your last project and your role in it.?31. What are the often used Stages or stages you worked with in your last project? Subscribe

A) Transformer, ORAOCI8/9, ODBC, Link-Partitioner, Link-Collector, Hash, ODBC, Aggregator, Sort.

Read / Answer32. How many jobs have you created in your last project? Subscribe

100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody Latest Answer: - I don't think these are the right numbers. Someone creating 100+ jobs in 6 months !! If you do the... Last Updated By Anjan Roy on September 15, 2005


33. Tell me the environment in your last projects Subscribe

Give the OS of the Server and the OS of the Client of your recent most project Latest Answer: server is unix and client machine i.e is ur machine where u design a job is windows xp professional... Last Updated By rcp on October 13, 2005


34. Did you Parameterize the job or hard-coded the values in the jobs? Subscribe

Always parameterized the job. Either the values are coming from Job Properties or from a ‘Parameter Manager’ – a third part tool. There is no way you will hard–code some parameters in your jobs. The o Latest Answer: hi please send me some real time questions in datastage for interview.i have interview on sunday for... Last Updated By umapathy on March 24, 2006


35. Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you haHave you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have taken in doing so?

Subscribe

Yes. The following are some of the steps; I have taken in doing so:1) Definitely take a back up of the whole project(s) by exporting the project as a .dsx file2) See that you are using the same parent





























Read / Answer36. What is Hash file stage and what is it used for? Subscribe

Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance. Latest Answer: We can also use the Hash File stage to avoid / remove dupilcate rowsby specifying the hash key on a... Last Updated By RamaPrasad Batchu on March 08, 2006


37. What are Static Hash files and Dynamic Hash files? Subscribe

As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size. Latest Answer: good explanation.... Last Updated By klsrao on June 12, 2007 (Answers: 3) Read / Answer

38. What versions of DS you worked with? Subscribe

DS 7.0.2/6.0/5.2 Read / Answer

39. What other ETL's you have worked with? Subscribe

Informatica and also DataJunction if it is present in your Resume. Latest Answer: ab-initiodatasatge EE parllel editionoracle -Etlthere are 7 ETL in market ! ... Last Updated By cndraa on December 09, 2005


40. Did you work in UNIX environment? Subscribe

Yes. One of the most important requirements. Latest Answer: some times u need to write unix progrms in back round !like batch progms ! bcz data stage can invoke... Last Updated By cndraa on December 09, 2005 41. How good are you with your PL/SQL? Subscribe

On the scale of 1-10 say 8.5-9 Latest Answer: u will not be writtinf pl/sql in datastage ! sql knowledge is enough ...... Last Updated By cndraa on January 31, 2006


42. Explain the differences between Oracle8i/9i? Subscribe

Latest Answer: Oracle 8i does not support pseudo column sysdate but 9i supportsOracle 8i we can create 256 columns ... Last Updated By Gnaneshwar on April 09, 2007


43. Do you know about INTEGRITY/QUALITY stage? Subscribe

Latest Answer: Qulaity Stage can be integrated with DataStage, In Quality Stage we have many stages like investigat... Last Updated By suganyasug on April 18, 2007


44. Do u know about METASTAGE? Subscribe

Latest Answer: MetaStage is a persistent metadata Directory that uniquely synchronizesmetadata across multiple sepa... Last Updated By spartankiya on February 19, 2007


































45. How did u connect to DB2 in your last project? Subscribe

Using DB2 ODBC drivers. Latest Answer: The following stages can connect to DB2 Database:ODBCDB2 Plug-in StageDynamic Relational Stage... Last Updated By gagan8877 on May 08, 2007


46. What are OConv () and Iconv () functions and where are they used? Subscribe

IConv() - Converts a string to an internal storage formatOConv() - Converts an expression to an output format. Latest Answer: iconv is used to convert the date into into internal format i.e only datastage can understand exampl... Last Updated By cndraa on January 30, 2006


47. What are Routines and where/how are they written and have you written any routines before? &nbWhat are Routines and where/how are they written and have you written any routines before?

Subscribe

Routines are stored in the Routines branch of the DataStage Repository, where you can create, view or edit. The following are different types of routines: 1) Transform functions

Read / Answer48. If worked with DS6.0 and latest versions what are Link-Partitioner and Link-Collector used for?

Subscribe

Link Partitioner - Used for partitioning the data.Link Collector - Used for collecting the partitioned data.

Read / Answer49. How did you handle reject data? Subscribe

Typically a Reject-link is defined and the rejected data is loaded back into data warehouse. So Reject link has to be defined every Output link you wish to collect rejected data. Rejected data is typi Latest Answer: we can handle rejected data by collecting them seperately in sequential file......... Last Updated By sunilsavalasang on October 18, 2006


50. What are other Performance tunings you have done in your last project to increase the performance oWhat are other Performance tunings you have done in your last project to increase the performance of slowly running jobs?

Subscribe

Staged the data coming from ODBC/OCI/DB2UDB stages or any database on the server using Hash/Sequential files for optimum performance also for data recovery in case job aborts.Tuned the OCI stage for '

Read / Answer51. How did you handle an 'Aborted' sequencer? Subscribe

In almost all cases we have to delete the data inserted by this from DB manually and fix the job and then run the job again.

Read / Answer52. What are Sequencers? Subscribe

Sequencers are job control programs that execute other jobs with preset Job parameters. Latest Answer: A sequencer allows you to synchronize the control flow of multiple activities in a job sequence. It ... Last Updated By jagan nimmagadda on January 10, 2006


53. How did u connect with DB2 in your last project? Subscribe

































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 drive

Read / Answer54. Read the String functions in DS Subscribe

Functions like [] -> sub-string function and ':' -> concatenation operatorSyntax: string [ [ start, ] length ]string [ delimiter, instance, repeats ]

Read / Answer55. What will you in a situation where somebody wants to send you a file and use that file as an input What will you in a situation where somebody wants to send you a file and use that file as an input or reference and then run job.

Subscribe

A. Under Windows: Use the 'WaitForFileActivity' under the Sequencers and then run the job. May be you can schedule the sequencer around the time the file is expected to arrive.B. Under UNIX:

Read / Answer56. How would call an external Java function which are not supported by DataStage? Subscribe

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 re

Read / Answer57. What is the utility you use to schedule the jobs on a UNIX server other than using Ascential DirectWhat is the utility you use to schedule the jobs on a UNIX server other than using Ascential Director?

Subscribe

Use crontab utility along with dsexecute() function along with proper parameters passed. Read / Answer

58. What are the command line functions that import and export the DS jobs? Subscribe

A. dsimport.exe- imports the DataStage components.B. dsexport.exe- exports the DataStage components. Latest Answer: Parameters: UserName,Password, Hostname, ProjectName,CurrentDirectory(C:/Ascential/DataStage7.5.1/ds... Last Updated By Pd on September 22, 2006


59. How will you determine the sequence of jobs to load into data warehouse? Subscribe

First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any).

Read / Answer60. The above might rise another question: Why do we have to load the dimensional tables first, then faThe above might rise another question: Why do we have to load the dimensional tables first, then fact tables:

Subscribe

As we load the dimensional tables the keys (primary) are generated and these keys (primary) are Foreign keys in Fact tables.

Read / Answer61. Tell me one situation from your last project, where you had faced problem and How did u solve it?

Subscribe

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 Read / Answer

62. Does the selection of 'Clear the table and Insert rows' in the ODBC stage send a TruncateDoes the selection of 'Clear the table and Insert rows' in the ODBC stage send a Truncate statement to the DB or does it do some kind of Delete logic.

Subscribe

There is no TRUNCATE on ODBC stages. It is Clear table blah blah and that is a delete from statement. On an OCI stage such as Oracle, you do have both Clear and Truncate options. They are radically di

Read / Answer63. How do you rename all of the jobs to support your new File-naming conventions? Subscribe

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 d

Read / Answer64. Difference between Hashfile and Sequential File? Subscribe

Latest Answer: Hash file can be stored in DS memory (Buffer) but Sequential file cannot be.. duplicates will be rem... Last Updated By Sanj333 on August 30, 2007


65. What is iconv and oconv functions? Subscribe

Latest Answer: Plz..Refer Q.227 for more information.... Last Updated By JD on November 29, 2006 (Answers: 3) Read / Answer

66. How can we join one Oracle source and Sequential file?. Subscribe

Latest Answer: . Join and look up used to join oracle and sequential file... Last Updated By J D Prasad Malneedi on September 29, 2005


67. How can we implement Slowly Changing Dimensions in DataStage?. Subscribe

Latest Answer: We can implement SCD in datastage 1.Type 1 SCD:insert else update in ODBC stage2.Type 2 SCD:insert n... Last Updated By suganyasug on April 18, 2007


68. How can we implement Lookup in DataStage Server jobs? Subscribe

Latest Answer: In server canvs we can perform 2 kinds of direct lookupsOne is by using a hashed file and the other ... Last Updated By Purnima on March 30, 2006


69. What are all the third party tools used in DataStage? Subscribe

Latest Answer: Contl-M job schedular... Last Updated By Upul on April 24, 2007 (Answers: 3) Read / Answer

70. what is the difference between routine and transform and function? Subscribe

Latest Answer: By using Routines we can return values but by transformers we cannot return values... Last Updated By suganyasug on April 18, 2007


71. what are the Job parameters? Subscribe
































Latest Answer: These Parameters are used to provide Administrative access and change run time values of the job.EDI... Last Updated By mallakishore on October 20, 2005


72. How can we improve the performance of DataStage jobs? Subscribe

Latest Answer: hi,i am learnining datastage server job, but i dont have project to analyze, if u have any projects ... Last Updated By vedamurthy on February 21, 2006


73. How can we create Containers? Subscribe

Latest Answer: hicontainers r speacial type of jobs in the datastage that will simplify the job design either in th... Last Updated By satish kumar on April 16, 2006


74. When should we use ODS? Subscribe

DWH's are typically read only, batch updated on a scheduleODS's are maintained in more real time, trickle fed constantly

Read / Answer75. Whats difference betweeen operational data stage (ODS) & data warehouse? Subscribe

Latest Answer: An operational data store (or "ODS") is a database designed to integrate data from multiple sources ... Last Updated By Dharmendra on September 22, 2006


76. How to handle Date convertions in Datastage? Convert a mm/dd/yyyy format to yyyy-dd-mm?

Subscribe

We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - External Convertion. Function to convert mm/dd/yyyy format to yyyy-dd-mm is Oconv(Iconv(Filedname,"D/M Latest Answer: we can achieve this conversion using transformer stage conversion functions in PX.Hanu.... Last Updated By hanug on May 06, 2007


77. How do you pass filename as the parameter for a job? Subscribe

Latest Answer: 1. Define the job parameter at the job level or Project level.2. Use the file name in the stage(sour... Last Updated By hanug on May 06, 2007


78. How will you call external function or subroutine from datastage? Subscribe

Latest Answer: U can call external functions, subroutines by using Before/After stage/job Subroutines : ExecSHExecD... Last Updated By gagan8877 on May 08, 2007


79. Dimensional modelling is again sub divided into 2 types. Subscribe

a)Star Schema - Simple & Much Faster. Denormalized form. b)Snowflake Schema - Complex with more Granularity. More normalized form. Latest Answer: i want routine documents and userdefined code of the routine? And real time senario in datastag... Last Updated By nukaraj on October 16, 2005


80. how to create batches in Datastage from command prompt Subscribe

































Read / Answer81. How do you eliminate duplicate rows? Subscribe

Latest Answer: If you dont have remove duplicates stge, you can use hash file to eliminate duplicates.... Last Updated By klsrao on April 23, 2007


82. What is DS Administrator used for - did u use it? Subscribe

Latest Answer: It is primarily used to create the Datastage project, assign the user roles to the project, set para... Last Updated By hanug on May 06, 2007


83. What is DS Designer used for - did u use it? Subscribe

Latest Answer: You use the Designer to build jobs by creating a visual design that models the flow and transformati... Last Updated By CNU on August 02, 2005


84. What about System variables? Subscribe

Latest Answer: If a new system variable is added in Windows, how can we access it in datastage?Thanks in advance... Last Updated By Ravi Kumar on March 15, 2006


85. How do you eliminate duplicate rows? Subscribe

Latest Answer: removal of duplicates done in two ways: 1. Use "Duplicate Data Removal" stage or 2. ... Last Updated By Mujeebur on August 15, 2005


86. What are types of Hashed File? Subscribe

Hashed File is classified broadly into 2 types. a) Static - Sub divided into 17 types based on Primary Key Pattern. b) Dynamic - sub divided into 2 types i) Generic ii Latest Answer: Hashed File is classified broadly into 2 types. a) Static - Sub divided into 17 types ba... Last Updated By prashanth on August 25, 2005


87. What is DS Manager used for - did u use it? Subscribe

Latest Answer: It is used to view and edit the contents of datastage repository.... Last Updated By Goutham on January 26, 2006


88. What is DS Director used for - did u use it? Subscribe

Latest Answer: Datastage Director is GUI to monitor, run, validate & schedule datastage server jobs. ... Last Updated By Tutu on May 11, 2006


89. How do we do the automation of dsjobs? Subscribe

Latest Answer: We can call Datastage Batch Job from Command prompt using 'dsjob'. We can also pass all the paramete... Last Updated By Pavan on December 05, 2005


90. How do you merge two files in DS? Subscribe

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. Latest Answer: Use the merge plug-in stage which can merge two files based on the defined key fields by using, INNE... Last Updated By gagan8877 on May 08, 2007


91. what's the difference between Datastage Developers and Datastage Designers. What are the skillwhat's the difference between Datastage Developers and Datastage Designers. What are the skill's required for this.

Subscribe

Read / Answer92. Importance of Surrogate Key in Data warehousing? Subscribe

Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a databas Latest Answer: can uplz elobrate, how performance improves, queryprocessing... Last Updated By vara on January 25, 2007


93. How do you fix the error "OCI has fetched truncated data" in DataStage Subscribe

Latest Answer: This kind of error occurs when you have CLOB in back end and Varchar in DataStage. So check the back... Last Updated By prasoon.pandey on August 29, 2007


94. what is difference between data stage and informatica Subscribe Asked by: neeluLatest Answer: Here is a very good articles on these differences... whic hhelps to get an idea.. basically it's dep... Last Updated By Jimmy on September 11, 2005


95. Could you please help me with a set of questions on Parallel Extender? Subscribe X Asked by: aadi

Read / Answer96. How many places u can call Routines? Subscribe 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 t Asked by: Mukesh Kumar Madhav

Read / Answer97. What is the Batch Program and how can generate ? Subscribe Batch programe is the programe it's generate run time to maintain by the datastage it self but u can easy to change own the basis of your requirement (Extraction, Transformation,Loading) .Batch progr Asked by: Mukesh Kumar Madhav

Read / Answer98. Scenario based Question ........... Suppose that 4 job control by the sequencer like (job 1, job 2,Scenario based Question ........... Suppose that 4 job control by the sequencer like (job 1, job 2, job 3, job 4 )if job 1 have 10,000 row ,after run the job only 5000 data has been loaded in target table remaining are not loaded and your job going to be aborted then.. How can short out the problem.

Subscribe

Suppose job sequencer synchronies or control 4 job but job 1 have problem, in this condition should go director and check it what type of problem showing either data type problem, warning massage, job Asked by: Mukesh Kumar Madhav

Read / Answer99. I want to process 3 files in sequentially one by one , how can i do that. while processing the fileI want to process 3 files in sequentially one by one , how can i do that. while processing the files it

Subscribe
































should fetch files automatically .hi Asked by: sekhar

Read / Answer100. What Happens if RCP is disable ? Subscribe Asked by: sekharLatest Answer: Runtime column propagation (RCP): If RCP is enabled for any job, and specifically for those stage wh... Last Updated By Venkata Maruthi on November 10, 2005


101. defaults nodes for datastage parallel Edition Subscribe Asked by: sekharLatest Answer: Actually the Number of Nodes depend on the number of processors in your system.If your system is sup... Last Updated By mallakishore on October 20, 2005


102. where does unix script of datastage executes weather in clinet machine or in server.suppose if it ewhere does unix script of datastage executes weather in clinet machine or in server.suppose if it eexcutes on server then it will execute ?

Subscribe

Asked by: sekharRead / Answer

103. how can we pass parameters to job by using file. Subscribe Asked by: sudhakar_geekLatest Answer: u can create a UNIX shell script which will pass the parameters to the job and u also can create log... Last Updated By Rajshankar on April 04, 2006


104. What is ' insert for update ' in datastage Subscribe Asked by: ashishLatest Answer: There is a lock for update option in Hashed File Stage, which locks the hashed file for updating whe... Last Updated By gagan8877 on May 10, 2007


105. Hi, What are the Repository Tables in DataStage and What are they? Subscribe Asked by: KumarLatest Answer: Dear User. A datawarehouse is a repository(centralized as well as distributed) of Data, able... Last Updated By Venkat on October 25, 2005


106. What is version Control? Subscribe Asked by: KumarLatest Answer: Version Controlstores different versions of DS jobsruns different versions of same jobreverts to pre... Last Updated By vick on October 30, 2005


107. what happends out put of hash file is connected to transformer ..what error it throughs Subscribe Asked by: bladeLatest Answer: If Hash file output is connected to transformer stage the hash file will consider as the Lookup file... Last Updated By shameerok on March 22, 2006


108. please list out the versions of datastage Parallel , server editions and in which year they are reaplease list out the versions of datastage Parallel , server editions and in which year they are realised.

Subscribe

Asked by: rcpRead / Answer



































109. what is merge and how it can be done plz explain with simple example taking 2 tables .......

Subscribe

Asked by: rcpLatest Answer: Merge stage in used for only Flat files in server edition... Last Updated By madan on April 29, 2006


110. How can I extract data from DB2 (on IBM iSeries) to the data warehouse via Datastage as the ETL tooHow can I extract data from DB2 (on IBM iSeries) to the data warehouse via Datastage as the ETL tool. I mean do I first need to use ODBC to create connectivity and use an adapter for the extraction and transformation of data? Thanks so much if anybody could provide an answer.

Subscribe

? Asked by: cyRead / Answer

111. How can I connect my DB2 database on AS400 to DataStage? Do I need to use ODBC 1st to open the dataHow can I connect my DB2 database on AS400 to DataStage? Do I need to use ODBC 1st to open the database connectivity and then use an adapter for just connecting between the two? Thanks alot of any replies.

Subscribe

Asked by: cyRead / Answer

112. what is the OCI? and how to use the ETL Tools? Subscribe OCI means orabulk data which used client having bulk data its retrive time is much more ie., your used to orabulk data the divided and retrived Asked by: ramanamvLatest Answer: OCI means oracle call interface i.e this acts like native tool to load oracle databaseU can just dra... Last Updated By Sharanu Patil on February 28, 2006


113. what is NLS in datastage? how we use NLS in Datastage ? what advantages in that ? at the time of inwhat is NLS in datastage? how we use NLS in Datastage ? what advantages in that ? at the time of installation i am not choosen that NLS option , now i want to use that options what can i do ? to reinstall that datastage or first uninstall and install once again ?

Subscribe

Asked by: sreedharRead / Answer

114. What is APT_CONFIG in datastage Subscribe Asked by: rcpLatest Answer: APT_CONFIG is just an environment variable used to idetify the *.apt file. Dont confuse that with *.... Last Updated By Raghu on December 09, 2005


115. how we use NLS function in Datastage? what are advantages of NLS function? where we can use that onhow we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? explain briefly?

Subscribe

Asked by: sreedhar KancherlaRead / Answer

116. what is merge ?and how to use merge? Subscribe merge is nothing but a filter conditions that have been used for filter condition Asked by: ramanamvLatest Answer: Merge stage is a processing stage, it can have any no of input link and only one output link. It is ... Last Updated By shameerok on March 22, 2006


117. what is difference between serverjobs & paraller jobs Subscribe Asked by: ramanamvLatest Answer: Server jobs can be run on SMP,MPP (Answers: 4) Read / Answer

































machines.Here performance is low i.e speed is lessParallel jobs ca... Last Updated By Sharanu Patil on February 28, 2006 118. what is DataStage Multi-byte, Single-byte file conversions in Mainframe jobs? what is UTF 8 ? whatswhat is DataStage Multi-byte, Single-byte file conversions in Mainframe jobs? what is UTF 8 ? whats use of UTF 8 ?

Subscribe

Asked by: ramireddyRead / Answer

119. what is Data stage Multi-byte, Single-byte file conversions?how we use that conversions in data stawhat is Data stage Multi-byte, Single-byte file conversions?how we use that conversions in data stage?

Subscribe

Asked by: ramireddyRead / Answer

120. How can ETL excel file to Datamart? Subscribe Asked by: perer*kingLatest Answer: open the ODBC Data Source Administrator found in the controlpanel/administrative tools.under the sys... Last Updated By machaiyer on July 24, 2006


121. what is the mean of Try to have the constraints in the 'Selection' criteria of the jobs iwhat is the mean of Try to have the constraints in the 'Selection' criteria of the jobs itself. This will eliminate the unnecessary records even getting in before joins are made?

Subscribe

Asked by: sudhakarRead / Answer

122. what is the meaning of the following..1)If an input file has an excessive number of rows and can bewhat is the meaning of the following..1)If an input file has an excessive number of rows and can be split-up then use standard 2)logic to run jobs in parallel3)Tuning should occur on a job-by-job basis. Use the power of DBMS.

Subscribe

Asked by: sudhakarRead / Answer

123. how to implement routines in data stage,have any one has any material for data stage pl send to me

Subscribe

pl send material for data stage Asked by: krishnaLatest Answer: there are 3 kind of routines is there in Datastage.1.server routines which will used in server jobs.... Last Updated By Sivarao on December 28, 2005


124. what is trouble shhoting in server jobs ? what are the diff kinds of errors encountered while runniwhat is trouble shhoting in server jobs ? what are the diff kinds of errors encountered while running any job?

Subscribe

Asked by: Ajju2005Read / Answer

125. how can u implement slowly changed dimensions in datastage? explain?2) can u join flat file and dathow can u implement slowly changed dimensions in datastage? explain?2) can u join flat file and database in datastage?how?

Subscribe

Asked by: ramaiahRead / Answer

126. How can you implement Complex Jobs in datastage Subscribe Asked by: ramaiah




































Latest Answer: if the job have good logic that is called as complex job.simply we can say Sce... Last Updated By arun on May 30, 2006


127. Does Enterprise Edition only add the parallel processing for better performance?Are any stages/tranDoes Enterprise Edition only add the parallel processing for better performance?Are any stages/transformations available in the enterprise edition only?

Subscribe

Asked by: stanisRead / Answer

128. how can you do incremental load in datastage? Subscribe Asked by: ramaiahLatest Answer: Incremental load means daily load.when ever you are selecting data from source, select the records w... Last Updated By Sivarao on December 27, 2005


129. If your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datasIf your running 4 ways parallel and you have 10 stages on the canvas, how many processes does datastage create?

Subscribe

Asked by: vishutRead / Answer

130. If data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arisIf data is partitioned in your job on key 1 and then you aggregate on key 2, what issues could arise?

Subscribe

Asked by: vishutRead / Answer

132. What is the difference between Datastage and Datastage TX? Subscribe Asked by: jalvaradoLatest Answer: Its a critical question to answer, but one thing i can tell u that Datastage Tx is not a ETL tool &a... Last Updated By Sharanu Patil on February 28, 2006


133. what are validations you perform after creating jobs in designer.what r the different type of errorwhat are validations you perform after creating jobs in designer.what r the different type of errors u faced during loading and how u solve them

Subscribe

Asked by: diwakarRead / Answer

134. How can I specify a filter command for processing data while defining sequential file output data?

Subscribe

Asked by: Mario FrankeLatest Answer: We have some thing called as after job subroutine and Before subroutine, with then we can execute th... Last Updated By Sreedhar on January 30, 2006


135. can we use shared container as lookup in datastage server jobs? Subscribe Asked by: sivaraoLatest Answer: Hi,I am using DataStage 7.5, Unix. we can use shared container more than one time in the job.T... Last Updated By Radhika on June 27, 2006


136. Hi!Can any one tell me how to extract data from more than 1 hetrogenious Sources.mean, example 1 seHi!Can any one tell me how to extract data from more than 1 hetrogenious Sources.mean, example 1 sequenal file, Sybase , Oracle in a singale Job.

Subscribe

Asked by: Ranga






































Read / Answer137. What is the exact difference betwwen Join,Merge and Lookup Stage?? Subscribe Asked by: PhantomLatest Answer: Also remember that to use Merge stage the key's field names MUST be equal in both&n... Last Updated By Ronaldo on August 05, 2006


138. hi! .. There are three different types of user-created stages available for PX. What are they? Whihi! .. There are three different types of user-created stages available for PX. What are they? Which would you use? What are the disadvantage for using each type?

Subscribe

Asked by: HrideshRead / Answer

139. what is the difference between buildopts and subroutines ? Subscribe Asked by: sekrLatest Answer: buildopts generates c++ code ( oops concept)subroutine :- is normal programe and u can call any wher... Last Updated By sekhu_da on December 22, 2006


140. what user varibale activity when it used how it used !where it is used with real example Subscribe Asked by: sekrLatest Answer: By using This User variable activity we can create some variables in the job sequnce,this variables ... Last Updated By jagan nimmagadda on March 28, 2006


141. DataStage from Staging to MDW is only running at 1 row per second! What do we do to remedy?

Subscribe

Asked by: JohnLatest Answer: Question should be more detailed. I am assuming that there are too many stages, which is causing pro... Last Updated By Ravi on May 29, 2006


142. what is the difference between datastage and informatica Subscribe Asked by: anunathLatest Answer: Informatica and DataStage both are ETL tools, which are used for data acquisition process... Last Updated By Mohan Krishnan Mannam on July 05, 2007


143. how is datastage 4.0 functionally different from the enterprise edition now?? what are the exact chhow is datastage 4.0 functionally different from the enterprise edition now?? what are the exact changes?

Subscribe

Asked by: vamsiRead / Answer

144. What are orabulk and bcp stages? Subscribe Asked by: ragkrisLatest Answer: ORABULK is used to load bulk data into single table of target oracle database.BCP is used to load bu... Last Updated By pavan on May 13, 2006


145. how to handle the rejected rows in datastage? Subscribe Asked by: vajraLatest Answer: we can handle rejected rows in two ways with help of Constraints in a Tansformer.1) By Putting on th... Last Updated By RamaPrasad Batchu on March 09, 2006





































146. it is possible to run parallel jobs in server jobs? Subscribe Asked by: mallikharjuna reddyLatest Answer: by configuring config file... Last Updated By server on parllel on April 21, 2006 (Answers: 5) Read / Answer

147. what are the differences between the data stage 7.0 and 7.5in server jobs? Subscribe Asked by: mallikharjuna reddyLatest Answer: There are lot of Diffrences: There are lot of new stages are available in DS7.5 For Eg: CDC ... Last Updated By Satheesh on March 15, 2006


148. How the hash file is doing lookup in serverjobs?How is it comparing the key values? Subscribe Asked by: priyabrataLatest Answer: Hashed File is used for two purpose: 1. Remove Duplicate Records 2. Then Used for reference looku... Last Updated By Satheesh on March 15, 2006


149. what is data set? and what is file set? Subscribe Asked by: mallikharjuna reddyLatest Answer: file set:- It allows you to read data from or write data to a file set. The stage can have a single ... Last Updated By srinivas on April 14, 2006


150. what are the enhancements made in datastage 7.5 compare with 7.0 Subscribe Asked by: uma maheswarLatest Answer: Complex file and Surrogate key generator stages are added in Ver 7.5 ... Last Updated By Rama Prasad on April 21, 2006


151. If I add a new environment variable in Windows, how can I access it in DataStage?Thanks in advance.

Subscribe

Asked by: raviatpalsLatest Answer: U can view all the environment variables in designer. U can check it in Job properties. U can add an... Last Updated By Rama Prasad on April 21, 2006


152. 1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance1.What about System variables? 2.How can we create Containers? 3.How can we improve the performance of DataStage? 4.what are the Job parameters? 5.what is the difference between routine and transform and function? 6.What are all the third party tools used in DataStage? 7.How can we implement Lookup in DataStage Server jobs? 8.How can we implement Slowly Changing Dimensions in DataStage?. 9.How can we join one Oracle source and Sequential file?. 10.What is iconv and oconv functions? 11.Differenc

Subscribe

Asked by: sdfsdfRead / Answer

153. it is possible to call one job in another job in server jobs? Subscribe Asked by: mallikharjuna reddyLatest Answer: Hi, I think we can call a job into another job. In fact calling doesn't sound good, beca... Last Updated By Alok Ranjan on April 05, 2006


154. what is hashing algorithm and explain breafly how it works? Subscribe Asked by: mallikharjuna reddyLatest Answer: Hi all, Can any one please explain the difference between GENERAL and SEQ.NUM hashiing algorithms? t... Last Updated By raj on March 24, 2006


155. what is OCI? Subscribe Asked by: mallikharjuna reddy








































Latest Answer: Oracle offers a proprietary call interface for C and C++ programmers that allows manipulation of dat... Last Updated By Rama Prasad on April 21, 2006


156. What is the NLS equivalent to NLS oracle code American_America.US7ASCII on Datastage NLS?

Subscribe

Asked by: MiranaRead / Answer

157. If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after If a DataStage job aborts after say 1000 records, how to continue the job from 1000th record after fixing the error?

Subscribe

Asked by: etlRead / Answer

158. how to implement type2 slowly changing dimensions in data stage?explain with example?

Subscribe

Asked by: mallikharjuna reddyLatest Answer: to develope scd type 2 us the update action in target as " insert new rows only"for this u need to m... Last Updated By Sivarao on May 15, 2006


159. Is it possible to move the data from oracle ware house to SAP Warehouse using with DATASTAGE Tool.

Subscribe

Asked by: aryaLatest Answer: We can use DataStage Extract Pack for SAP R/3 and DataStage Load Pack for SAP BW ... Last Updated By Rama Prasad on April 21, 2006


160. Can you convert a snow flake schema into star schema? Subscribe Yes, We can convert by attaching one hierarchy to lowest level of another hierarchy. Asked by: dwandbiLatest Answer: No. It is not possible... Last Updated By katta on February 24, 2007 (Answers: 1) Read / Answer

161. How much would be the size of the database in DataStage ?What is the difference between Inprocess aHow much would be the size of the database in DataStage ?What is the difference between Inprocess and Interprocess ?

Subscribe

Asked by: MadhusudanRead / Answer

162. How I can convert Server Jobs into Parallel Jobs? Subscribe Asked by: frodegLatest Answer: Could'nt we just copy the whole job design and stages using your mouse and paste into a new parallel... Last Updated By John on February 06, 2007


163. What is the max capacity of Hash file in DataStage? Subscribe Asked by: LakLatest Answer: Hello,Take a look at the uvconfig file:# 64BIT_FILES - This sets the default mode used to# &nbs... Last Updated By Alfons Garcia on May 05, 2006


164. how to use rank&updatestratergy in datastage Subscribe Asked by: subbuLatest Answer: U can use it with ODBC stage by writing proper SQl quries... Last Updated By shri on September 15, 2006


165. What is the difference between drs and odbc stage Subscribe








































Asked by: sowmyaLatest Answer: To answer your question the DRS stage should be faster then the ODBC stage as it uses native databas... Last Updated By Zabi81 on June 01, 2006


166. what is meaning of file extender in data stage server jobs.can we run the data stage job from one jwhat is meaning of file extender in data stage server jobs.can we run the data stage job from one job to another job that file data where it is stored and what is the file extender in ds jobs.

Subscribe

Asked by: venkateswarluRead / Answer

167. # How does DataStage handle the user security? Subscribe Asked by: debasis_mohantyLatest Answer: we have to create users in the Administrators and give the necessary priviliges to users.... Last Updated By chereddy on May 18, 2006


168. What are the Steps involved in development of a job in DataStage? Subscribe Asked by: debasis_mohantyLatest Answer: The steps required are:select the datasource stage depending upon the sources for ex:flatfile,databa... Last Updated By chereddy on May 18, 2006


169. Briefly describe the various client components? Subscribe Asked by: debasis_mohantyLatest Answer: There are four client components DataStage Designer. A design interface used to create DataStage app... Last Updated By Ankit Agrawal on May 13, 2006


170. What is a project? Specify its various components? Subscribe Asked by: debasis_mohantyLatest Answer: You always enter DataStage through a DataStage project. When you start a DataStage client you are pr... Last Updated By silpabalram on May 15, 2006


171. * What are constraints and derivation?* Explain the process of taking backup in DataStage?*What are* What are constraints and derivation?* Explain the process of taking backup in DataStage?*What are the different types of lookups available in DataStage?

Subscribe

Asked by: debasis_mohantyRead / Answer

172. Will the data stage consider the second constraint in the transformer once the first condition is sWill the data stage consider the second constraint in the transformer once the first condition is satisfied ( if the link odering is given)

Subscribe

Asked by: rajiRead / Answer

173. How to remove duplicates in server job Subscribe Asked by: PriyankaLatest Answer: Explain... Last Updated By sudheermukkamalla on August 07, 2006 (Answers: 3) Read / Answer

174. How do you do Usage analysis in datastage ? Subscribe Asked by: arunLatest Answer: Hi,1. If u want to know some job is a part of a sequence, then in the Manager right click the job an...










































Last Updated By Zabi81 on June 01, 2006 175. purpose of using the key and difference between Surrogate keys and natural key Subscribe Asked by: CNDRAALatest Answer: natural key :- seq no system assigned ..skey :- user assigend ! u can start with any number like 100... Last Updated By sekhu_da on November 14, 2006


176. what are the environment variables in datastage?give some examples? Subscribe Asked by: mallikharjuna reddyLatest Answer: Hi,Theare are the variables used at the project or job level.We can use them to to configure the job... Last Updated By Hanu on June 08, 2006


177. wht is the difference beteen validated ok and compiled in datastage. Subscribe Asked by: kishore

Read / Answer178. how we can create rank using datastge like in informatica. Subscribe Asked by: kishoreLatest Answer: Hi,if ranking means that belowprop_id rank1 11... Last Updated By Murat Nur on December 28, 2006


179. What is difference between Merge stage and Join stage? Subscribe Asked by: MadhavLatest Answer: Someone was saying that join does not support more than two input , while merge support two or more ... Last Updated By Alok Ranjan on June 08, 2006


180. Hican any one can explain what areDB2 UDB utilitiesub Subscribe Asked by: ub

Read / Answer181. what is PROFILE STAGE , QUALITY STAGE,AUDIT STAGE in datastage..please expalin in detail.thanks in what is PROFILE STAGE , QUALITY STAGE,AUDIT STAGE in datastage..please expalin in detail.thanks in adv

Subscribe

Asked by: xxxRead / Answer

182. hi all what is auditstage,profilestage,qulaitystages in datastge please explain indetail Subscribe Asked by: profilestage

Read / Answer183. how to implement type2 slowly changing dimenstion in datastage? give me with example?

Subscribe

Asked by: mallikharjuna reddyLatest Answer: you can use change-capture stage - This will tell you whether the source record is insert/update/mod... Last Updated By ajinkyac on June 16, 2007


184. how to find the number of rows in a sequential file? Subscribe Asked by: mallikharjuna reddyLatest Answer: Using Row Count system variable... Last Updated By malla on June 29, 2006 (Answers: 1) Read / Answer

185. where actually the flat files store?what is the path? Subscribe Asked by: mallikharjuna reddy







































Latest Answer: The flat files will be stored in the unix box ,if u r environment is Unix,U need to specify th... Last Updated By Bharath narahari on December 05, 2006


186. what are the different types of lookups in datastage? Subscribe Asked by: mallikharjuna reddyLatest Answer: U can also use the sparse look up property when u have large data in the look up table ..... ... Last Updated By Bharath narahari on December 05, 2006


187. What are the most important aspects that a beginner must consider doin his first DS project ?

Subscribe

Asked by: Vince O'ReillyLatest Answer: Apart from DWH concepts and different stage knowledge,try to use the director to find out errors and... Last Updated By Bharath narahari on December 05, 2006


188. how we can call the routine in datastage job?explain with steps? Subscribe Asked by: mallikharjuna reddyLatest Answer: In transformer stage we have to edit the field and click dsRoutines.It will prompt to select the rou... Last Updated By malla on June 29, 2006


189. what is job control?how it is developed?explain with steps? Subscribe Asked by: mallikharjuna reddy

Read / Answer190. what is job control?how can it used explain with steps? Subscribe Asked by: mallikharjuna reddyLatest Answer: JCL defines Job Control Language it is ued to run more number of jobs at a time with or without usin... Last Updated By shiva on June 29, 2006


191. how to find errors in job sequence? Subscribe Asked by: mallikharjuna reddyLatest Answer: Just go to th eparticular jobs log... Last Updated By Bharath narahari on December 05, 2006 (Answers: 2) Read / Answer

192. it is possible to access the same job two users at a time in datastage? Subscribe Asked by: mallikharjuna reddyLatest Answer: No chance ..... u have to kill the job process ... Last Updated By Bharath narahari on December 05, 2006


193. what is the meaning of instace in data stage?explain with examples? Subscribe Asked by: mallikharjuna reddy

Read / Answer194. If the size of the Hash file exceeds 2GB..What happens? Does it overwrite the current rows?

Subscribe

Asked by: RohitLatest Answer: it overwrites the file... Last Updated By shiva on June 29, 2006 (Answers: 1) Read / Answer

195. how to drop the index befor loading data in target and how to rebuild it in data stage? Subscribe Asked by: mallikharjuna reddyLatest Answer: This can be achieved by "Direct Load" option of SQLLoaded utily.... Last Updated By soumita deb on July 25, 2006




































196. How to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file aHow to parametarise a field in a sequential file?I am using Datastage as ETL Tool,Sequential file as source.

Subscribe

Asked by: K.Bala SubrahmanyamRead / Answer

197. how to kill the job in data stage? Subscribe Asked by: mallikharjuna reddyLatest Answer: U can also do it by using data stage director clean up resources... Last Updated By Bharath narahari on December 05, 2006


198. where we use link partitioner in data stage job?explain with example? Subscribe Asked by: mallikharjuna reddyLatest Answer: We use Link Partitioner in DataStage Server Jobs.The Link Partitioner stage is an active stage which... Last Updated By shiva on June 29, 2006


199. What is the difference between sequential file and a dataset? When to use the copy stage?

Subscribe

Asked by: vsarita80Latest Answer: hi allsequential file:it act as a source & permanent storage for target.it 's extend is .txt.dat... Last Updated By kirupakaran on December 12, 2006


200. what is the purpose of exception activity in data stage 7.5? Subscribe Asked by: mallikharjuna reddyLatest Answer: The stages followed by exception activity will be executed whenever there is an unknown error occurs... Last Updated By vimalt on July 13, 2006


201. How i create datastage Engine stop start script.Actually my idea is as below.!#bin/bashdsadm - userHow i create datastage Engine stop start script.Actually my idea is as below.!#bin/bashdsadm - usersu - rootpassword (encript)DSHOMEBIN=/Ascential/DataStage/home/dsadm/Ascential/DataStage/DSEngine/binif check ps -ef | grep DataStage (client connection is there) { kill -9 PID (client connection) }uv -admin - stop > dev/nulluv -admin - start > dev/nullverify processcheck the connectionecho "Started properly"run it as dsadm

Subscribe

Asked by: DHEERENDRA SINGHRead / Answer

202. How do u check for the consistency and integrity of model and repository? Subscribe Asked by: mahesh

Read / Answer203. What does separation option in static hash-file mean? Subscribe Asked by: maheshLatest Answer: The different hashing algorithms are designed to distribute records evenly among the groups of the f... Last Updated By Navatha on July 06, 2006


204. give one real time situation where link partitioner stage used? Subscribe Asked by: mallikharjuna reddyLatest Answer: If we want to send more data from the source to the targets quickly we will be using the link partio... Last Updated By praveenkumar on August 20, 2006


205. What is the difference between Symetrically parallel processing,Massively parallel processing?

Subscribe




































Asked by: baluRead / Answer

206. How to implement slowly changing dimentions in Datastage? Subscribe Asked by: baluLatest Answer: In Informatica powercenter, there is a way to implement slowly changing dimension through wizard. Da... Last Updated By vimalt on July 13, 2006


207. what is data stage engine?what is its purpose? Subscribe Asked by: mallikharjuna reddyLatest Answer: Datastage sever contains Datastage engine DS Server will interact with Client components and Reposit... Last Updated By JOHN DANIEL on November 08, 2006


208. what is the size of the flat file? Subscribe Asked by: mallikharjuna reddyLatest Answer: The flat file size depends amount of data contained by that flat file... Last Updated By Dharmendra on September 22, 2006


209. how to improve the performance of hash file? Subscribe Asked by: mallikharjuna reddyLatest Answer: Hi You can inprove performance of hashed file by 1 .Preloading hash file into memory -->this can ... Last Updated By Saket Garg on July 04, 2006


210. Actually my requirement is like that :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMActually my requirement is like that :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif we run that job the target file names are like this sale_header_1_20060206 & sale_line_1_20060206.if we run next

Subscribe

Asked by: sreedhar kancherlaRead / Answer

211. Other than Round Robin, What is the algorithm used in link collecter? Also Explain How it will worOther than Round Robin, What is the algorithm used in link collecter? Also Explain How it will works?

Subscribe

Asked by: mallikharjuna reddyRead / Answer

212. Have you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you haHave you ever involved in updating the DS versions like DS 5.X, if so tell us some the steps you have

Subscribe

Asked by: geek61Read / Answer

213. My requirement is like this :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALEMy requirement is like this :Here is the codification suggested: SALE_HEADER_XXXXX_YYYYMMDD.PSVSALE_LINE_XXXXX_YYYYMMDD.PSVXXXXX = LVM sequence to ensure unicity and continuity of file exchangesCaution, there will an increment to implement.YYYYMMDD = LVM date of file creation COMPRESSION AND DELIVERY TO: SALE_HEADER_XXXXX_YYYYMMDD.ZIP AND SALE_LINE_XXXXX_YYYYMMDD.ZIPif we run that job the target file names are like this sale_header_1_20060206 & sale_line_1_20060206.If we run next time means the

Subscribe

Asked by: sreedhar k






























Read / Answer214. How to know the no.of records in a sequential file before running a server job? Subscribe Asked by: laxmanLatest Answer: if your environment is unix , you can check with wc -l filename command.... Last Updated By vijaya kumar peruri on July 28, 2006


215. what is the transaction size and array size in OCI stage?how these can be used? Subscribe Asked by: mallikharjuna reddyLatest Answer: Transaction Size - This field exists for backward compatibility, but it is ignored for release ... Last Updated By laxman on July 24, 2006


216. What are the Environmental variables in Datastage? Subscribe Asked by: Chidanand

Read / Answer217. how do u clean the datastage repository. Subscribe Asked by: kashifLatest Answer: CLEAR.FILE &PH&... Last Updated By Bunny on August 25, 2006 (Answers: 2) Read / Answer

218. What is the difference between Transform and Routine in DataStage? Subscribe Asked by: ETLLatest Answer: Transformar transform the data from one from to another form .where as Routines describes the busine... Last Updated By JOHN DANIEL on November 08, 2006


219. How to run the job in command prompt in unix? Subscribe Asked by: BadriLatest Answer: Using dsjob command,-optionsdsjob -run -jobstatus projectname jobnameThanks,Srini... Last Updated By Srini on August 01, 2006


220. HI How can we create read only jobs in Datastage. Subscribe Asked by: BABU SLatest Answer: in export there is an options just CLICK ON OPTIONS TAB THEN THERE UNDER INCLUDE OPTIONU WILL FIND R... Last Updated By mady on August 18, 2006


221. How do you call procedures in datastage? Subscribe Asked by: ReddyLatest Answer: Use the Stored Procedure Stage... Last Updated By Pradeep Menon on August 08, 2006 (Answers: 1) Read / Answer

222. How do you remove duplicates without using remove duplicate stage? Subscribe Asked by: ReddyLatest Answer: You can do it at any stage.Just do a hash partion of the input data and check the options Sort and U... Last Updated By c2 on September 05, 2006


223. What are the new features of Datastage 7.1 from datastage 6.1 Subscribe Asked by: BABU

Read / Answer224. What is the difference between DataStage and DataStage Scripting? Subscribe Asked by: Gudduy

Read / Answer



































225. What is environment variables?what is the use of this? Subscribe Asked by: RamLatest Answer: Thanks... Last Updated By Ram on August 17, 2006 (Answers: 2) Read / Answer

226. Can you tell me for what puorpse .dsx files are used in the datasatage Subscribe Asked by: praveen kumar. GLatest Answer: you can as well export the Datastage jobs in .xml format......... Last Updated By srividya on August 25, 2006


227. Hiwhat is difference betweend ETL and ELT? Subscribe Asked by: SrinubabuLatest Answer: ETL-> transformation takes place in staging area and in ELT-> transormation takes at either so... Last Updated By sunil on October 18, 2006


228. if we using two sources having same meta data and how to check the data in two sorces is same or nif we using two sources having same meta data and how to check the data in two sorces is same or not?and if the data is not same i want to abort the job ?how we can do this?

Subscribe


229. How can I schedule the cleaning of the file &PH& by dsjob? Subscribe Asked by: BernardoLatest Answer: Create a job with dummy transformer and sequentail file stage. In Before Job subroutine, use ExecTCL... Last Updated By rameshrr3 on November 10, 2006


230. what is quality stage and profile stage? Subscribe Asked by: nvsmithaLatest Answer: ProfileStage is used for analysing data and their relationships.... Last Updated By Guest on June 23, 2007


231. how to find the process id?explain with steps? Subscribe Asked by: mallikharjuna reddyLatest Answer: U can also use Data stage Administrator.Just click on the project and execute command ,just follow t... Last Updated By Bharath narahari on December 05, 2006


232. how to distinguish the surogate key in different dimensional tables?how can we give for different dhow to distinguish the surogate key in different dimensional tables?how can we give for different dimension tables?

Subscribe


233. What is the difference bitween OCI stage and ODBC stage? Subscribe Asked by: pavanLatest Answer: Oracle OCI: · We... Last Updated By Radha on September 07, 2006 (Answers: 1) Read / Answer

234. Could anyone plz tell abt the full details of Datastage Certification.Title of Certification?AmountCould anyone plz tell abt the full details of Datastage Certification.Title of Certification?Amount for Certification test?Where can v get the Tutorials available for certification?Who is Conducting the Certification Exam?Whether any training institute or person for guidens?I am very much pleased if anyone enlightwn me abt the above saidSuresh

Subscribe



































Asked by: SureshRead / Answer

235. Is there any difference b/n Ascential DataStage and DataStage. Subscribe Asked by: JaganLatest Answer: There is no difference between Ascential Datastage and Datastage ,Now its IBM websphere Datastage ea... Last Updated By meenamanukondu on September 06, 2006


236. Hello,Can both Source system(Oracle,SQLServer,...etc) and Target Data warehouse(may be oracle,SQLSeHello,Can both Source system(Oracle,SQLServer,...etc) and Target Data warehouse(may be oracle,SQLServer..etc) can be on windows environment or one of the system should be in UNIX/Linux environment.Thanks,Jagan

Subscribe

Asked by: jaganRead / Answer

237. What is Runtime Column Propagation and how to use it? Subscribe Asked by: pratap.beheraLatest Answer: If your job has more columns which are not defined in metadata if runtime propagation is enabled it ... Last Updated By rajeev on September 08, 2006


238. how we use the DataStage Director and its run-time engine to schedule running the solution, testinghow we use the DataStage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting e/xecutable versions on ad hoc or scheduled basis?

Subscribe

Asked by: kamalRead / Answer

239. What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

Subscribe

Asked by: Devi RameshRead / Answer

240. What is the difference between reference link and straight link ? Subscribe Asked by: DharmendraLatest Answer: hiThe differerence between reference link and straight link isThe straight link is the one where dat... Last Updated By starsaran007 on September 30, 2006


241. I have few questions1. What ar ethe various process which starts when the datastage engine starts?2I have few questions1. What ar ethe various process which starts when the datastage engine starts?2. What are the changes need to be done on the database side, If I have to use dB2 stage?3. datastage engine is responsible for compilation or execution or both?

Subscribe

Asked by: kannuRead / Answer

242. How to write and execute routines for PX jobs in c++? Subscribe Asked by: Rajesh DevabhaktuniLatest Answer: You have to write routine in C++ (g++ in Unix). then you have to create a object file. provide this ... Last Updated By Kiran on November 02, 2006


243. 1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv1 1. Difference between Hashfile and Sequential File?. What is modulus?2 2. What is iconv and oconv functions?.3 3. How can we join one Oracle source and Sequential file?.4 4. How can we implement Slowly Changing Dimensions in DataStage?.5 5. How can we implement Lookup in DataStage Server

Subscribe




































jobs?.6 6. What are all the third party tools used in DataStage?.7 7. what is the difference between routine and transform and function?.8 8. what are the Job parameters?.9 9. Plug-in?.10 10.How can we improvAsked by: Zias

Read / Answer244. what is pivot stage?why are u using?what purpose that stage will be used? Subscribe Asked by: pavanLatest Answer: First of all thanks to srilaxmi for your skill in pivot stage.Pivot stage supports only horizontal p... Last Updated By laxman on October 24, 2006


245. how to eleminate duplicate rows in data stage? Subscribe Asked by: pavanLatest Answer: There are two methods for eleminating duplicate rows in datastage1. Using hash file stage (Specify t... Last Updated By ravi on December 11, 2006


246. how can we load source into ODS? Subscribe Asked by: yukthiLatest Answer: What is ur source?. Depending on type of source, you have to use respective stage.like oracle enterp... Last Updated By hanug on December 12, 2006


247. how do we create index in data satge? Subscribe Asked by: yukthiLatest Answer: What type of index are you looking for ? If it is only based on rows, use @inrownum or @outrownum... Last Updated By Mobashshar on August 08, 2007


248. how can we create environment variables in datasatage? Subscribe Asked by: yukthiLatest Answer: Hi This mostely will comes under Administrator part.As a Designer only we can add directly byDesigne... Last Updated By ashok on October 12, 2006


249. what is the difference between static hash files n dynamic hash files? Subscribe Asked by: yukthiLatest Answer: thanxs...... Last Updated By yukthi on October 12, 2006 (Answers: 2) Read / Answer

250. what is a routine? Subscribe Asked by: yukthiLatest Answer: Routine is user defined functions that can be reusable with in the project.... Last Updated By Kiran on November 02, 2006


251. How can we Test jobs in Datastage?? Subscribe Asked by: yukthiLatest Answer: Hi Configuration of u'r system is fine. I don't think therez problem in the installation too.there r... Last Updated By kumar on November 22, 2006


252. What is the use of Hash file??insted of hash file why can we use sequential file itself? Subscribe Asked by: yukthiLatest Answer: these files are stored in the memory hence faster performance than from a sequential file... Last Updated By jessa on October 24, 2006


253. how can we test the jobs? Subscribe






































Asked by: yukthiLatest Answer: Thanxs...... Last Updated By yukthi on October 12, 2006 (Answers: 2) Read / Answer

254. what is an environment variable?? Subscribe Asked by: yukthiLatest Answer: Here is the full FAQ on this topic:Creating project specific environment variables- Start up DataSta... Last Updated By the_xxx on March 21, 2007


255. how can we generate a surrogate key in server/parallel jobs? Subscribe Asked by: praveenLatest Answer: You can also generate the surrogate key in the database using the sequence generator.... Last Updated By Kiran on November 02, 2006


256. how to read the data from XL FILES?explain with steps? Subscribe Asked by: mallikharjuna reddyLatest Answer: Create a new DSN for the Excel driver and choose the workbook from which u want dataSelect the ODBC ... Last Updated By S on October 30, 2006


257. how to distinguish the surrogate key in different dimentional tables? Subscribe Asked by: mallikharjuna reddyLatest Answer: the Surrogate key will be the key field in the dimensions.... Last Updated By Kiran on November 02, 2006


258. whats the meaning of performance tunning techinque,Example?? Subscribe Asked by: yukthiLatest Answer: HI,is this only related with server jobs .because in parallel extender these things are taken care b... Last Updated By trinity on October 28, 2006


259. hi..Disadvantages of staging area Thanks,Jagan Subscribe Asked by: JaganLatest Answer: Yes, its like a disadvantage of staging area, it takes more space in database and it may not be cost... Last Updated By RAVI on March 02, 2007


260. how to read the data from XL FILES?my problem is my data file having some commas in data,but we arhow to read the data from XL FILES?my problem is my data file having some commas in data,but we are using delimitor is| ?how to read the data ,explain with steps?

Subscribe


261. differentiate between pipeline and partion parallelism? Subscribe Asked by: sivanov21Latest Answer: consider three cpu connected in series. When data is being fed into the first one,it start proc... Last Updated By manraj on October 25, 2006


262. what are the main diff between server job and parallel job in datastage Subscribe Asked by: prasannaLatest Answer: server jobs can compile and run with in datastage server but parallel jobs can compile and run with ... Last Updated By N.sukumar on December 26, 2006


263. what is complex stage?In which situation we are using this one? Subscribe Asked by: BHARETH REDDY




































Latest Answer: A complex flat file can be used to read the data at the intial level. By using CFF, we can read ASCI... Last Updated By amardeep.reddy on December 06, 2006


264. Why is hash file is faster than sequential file n odbc stage?? Subscribe Asked by: yukthiLatest Answer: Hash file is indexed. Also it works under hashing algo. That's why the search is faster in hash file... Last Updated By Lavanya on November 08, 2006


265. how can we improve performance in aggregator stage?? Subscribe Asked by: yukthiLatest Answer: Select the most appropriate partitioning method based on the data analysis. Hash partitoning perform... Last Updated By prav2000 on December 21, 2006


266. What is Integrated & Unit testing in DataStage ? Subscribe Asked by: izackLatest Answer: Unit Testing: &nb... Last Updated By BALU on December 04, 2006 (Answers: 1) Read / Answer

267. Why job sequence is use for? what is batches?what is the difference between job sequence and batcheWhy job sequence is use for? what is batches?what is the difference between job sequence and batches?

Subscribe

Asked by: prashantRead / Answer

268. Hot Fix for ODBC Stage for AS400 V5R4 in Data Stage 7.1 Subscribe Asked by: Girolamo Falbo

Read / Answer269. what are two types of hash files?? Subscribe Asked by: yukthiLatest Answer: the two type of hash file are, 1) static and 2) dynamic,,,,, the dynamic hash file is again subdivid... Last Updated By prashant narayani on December 27, 2006


270. how can we improve the job performance? Subscribe Asked by: sivanov21Latest Answer: We can put hash file in lookup. This will index the input data based on key column (which we define)... Last Updated By Bhaskar on December 29, 2006


271. Where can you output data using the Peek Stage? Subscribe Asked by: RamLatest Answer: The output of peek stage can be viewed in director LOG and also it can be saved as a seperate text f... Last Updated By karthik on February 21, 2007


272. For what purpose is the Stage Variable is mainly used? Subscribe Asked by: Prashant NarayaniLatest Answer: The stage variable can be used in situations where U want to Store a Previous record value in a vari... Last Updated By Srinivasa R Gummadi on November 19, 2006


273. what are different types of file formats?? Subscribe






































Asked by: yukthiLatest Answer: .csv files. dxs files( standard extension of data stage)... Last Updated By PRASHANT NARAYANI on December 26, 2006


274. What are different dimension table in your project??Plz explain me with an example?? Subscribe Asked by: yukthiLatest Answer: hi, for this question u cant say exact number of dimension tables in your project,, so tell hi... Last Updated By PRASHANT NARAYANI on December 26, 2006


275. What is a sequential file that has single input link?? Subscribe Asked by: yukthiLatest Answer: Sequential file always hasÂ single link because its it cannot accept the multiple links or threads.D... Last Updated By Raghu on August 01, 2007


276. What is the use of tunnable?? Subscribe Asked by: yukthiLatest Answer: Tunable is project property in Datastage Administrator, in that we can change the value of cache siz... Last Updated By Ravi on December 18, 2006


277. What is the sequencer stage?? Subscribe Asked by: yukthiLatest Answer: Lets say there are two jobs (J1 & J2) as the input links and one job (J3) as output link for a s... Last Updated By amardeep.reddy on December 06, 2006


278. What are different types of star schema?? Subscribe Asked by: yukthiLatest Answer: Multi star schema or galaxy schema is one of the type of star schema... Last Updated By PRASHANT NARAYANI on December 27, 2006


279. What is the use of job controle?? Subscribe Asked by: yukthiLatest Answer: Job control is used for scripting. With the help of scripting, we can set parameters for a caller jo... Last Updated By Vijaykumar Kharwandikar on December 28, 2006


280. What is the alternative way where we can do job control?? Subscribe Asked by: yukthiLatest Answer: Jobcontrol can be done using :Datastage job SequencersDatastage Custom routinesScriptingScheduling t... Last Updated By Vennela17 on February 22, 2007


281. What is user activity in datastage? Subscribe Asked by: AnanthLatest Answer: The User variable activity stage defines some variables,those are used in the sequence in future..... Last Updated By Prashant Narayani on December 29, 2006


282. What does # indicate in environment variables? Subscribe Asked by: PRASHANT NARAYANILatest Answer: It is used to identify the parameter.... Last Updated By Vijaykumar Kharwandikar on December 28,







































2006 283. Is it possible to query a hash file? Justify your answer... Subscribe Asked by: prashant narayaniLatest Answer: You can also use a Universe stage if the data is need in your job. I don't recall all details when I... Last Updated By John on February 08, 2007


284. Suppose you have table "sample" & three columns in that tablesample:Cola Colb Colc1 Suppose you have table "sample" & three columns in that tablesample:Cola Colb Colc1 10 1002 20 2003 30 300Assume: cola is primary keyHow will you fetch the record with maximum cola value using data stage tool into the target system

Subscribe

Asked by: WaseemRead / Answer

285. How to run a job using command line? Subscribe Asked by: Prashant NarayaniLatest Answer: dsjob -run -jobstatus projectname jobname... Last Updated By ram on January 07, 2007 (Answers: 1) Read / Answer

286. What is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standard AscentiWhat is the diffrence between IBM Web Sphere DataStage 7.5 (Enterprise Edition ) & Standard Ascential DataStage 7.5 Version ?

Subscribe

Asked by: izackRead / Answer

287. What is the diffrence between the Dynamic RDBMS Stage & Static RDBMS Stage ? Subscribe Asked by: izack

Read / Answer288. What is the difference betwen Merge Stage and Lookup Stage? Subscribe Asked by: RamLatest Answer: Lookup stage:1. Used to perform lookups.2. Multiple reference links, single input link, single outpu... Last Updated By srinivasguptha on January 29, 2007


289. What is Fact loading, how to do it? Subscribe Asked by: Prashant NarayaniLatest Answer: Once we have loaded our dimensions, then as per business requirements we identify the facts(columns ... Last Updated By Amjad on February 23, 2007


290. Aggregators – What does the warning “Hash table has grown to ‘xyz’ …Aggregators – What does the warning “Hash table has grown to ‘xyz’ ….” mean?

Subscribe

Asked by: ManrajRead / Answer

291. Which partition we have to use for Aggregate Stage in parallel jobs ? Subscribe Asked by: izackLatest Answer: I think the above answer is a little misleading. Most of the time you'll be using aggr. stage in par... Last Updated By harishsj on August 09, 2007


292. Where we can use these Stages Link Partetionar, Link Collector & Inter Process (OCI) Stage whether Where we can use these Stages Link Partetionar, Link Collector & Inter Process (OCI) Stage whether in Server Jobs or in Parallel Jobs ? And SMP is a Parallel or Server ?

Subscribe

Asked by: izack






































Read / Answer293. What is TX and what is the use of this in DataStage ? As I know TX stand for Transformer Extender, What is TX and what is the use of this in DataStage ? As I know TX stand for Transformer Extender, but I don't know how it will work and where we will used ?

Subscribe

Asked by: izackRead / Answer

294. How to enable the datastage engine? Subscribe Asked by: sivanov21

Read / Answer295. what is hashing algorithm? Subscribe Asked by: sivanov21Latest Answer: Hashing is a technic how you store the data in dynamic files.There are few algorithams for doing thi... Last Updated By Raghu on August 01, 2007


296. what is the difference between RELEASE THE JOB and KILL THE JOB? Subscribe Asked by: sivanov21Latest Answer: HiRelease the job is to release the job from any dependencies and run it.Kill the job means kill the... Last Updated By deepa on February 26, 2007


297. How can we remove duplicates using sort stage? Subscribe Asked by: sivanov21Latest Answer: TreeSet set = new TreeSet(Arrays.asList(names)); ... Last Updated By Alex on February 28, 2007


298. In which situation,we are using RUN TIME COLUMN PROPAGATION option? Subscribe Asked by: sivanov21Latest Answer: Run time column propagation is used in case of partial schema usage. when we only know about the col... Last Updated By poonam on February 14, 2007


299. What is repository? Subscribe Asked by: sivanov21Latest Answer: Repository is a content which is having all metadata (information).... Last Updated By prasad on February 24, 2007


300. what is the difference between datasatge and datastage TX? Subscribe Asked by: sivanov21Latest Answer: Hi, WebSphere Transformation Extender (WTX) is the universal transformation engine for WebSphere th... Last Updated By veeru_veeru on February 13, 2007


301. how find duplicate records using transformer stage in server edition Subscribe Asked by: prasadLatest Answer: Transformer stage to identify and remove duplicates from one output, and direct all input rows to an... Last Updated By the_xxx on March 20, 2007


302. Type 30D hash file is GENERIC or SPECIFIC? Subscribe Asked by: sivanov21Latest Answer: Type30 Files are Dynamic files.HTHRaghu Mule... Last Updated By Raghu on August 01, 2007




































303. what is the use of environmental variables? Subscribe Asked by: sivanov21Latest Answer: Enviroment Variables are the one who set the enviroments.Oce you set these varicables in datastage y... Last Updated By raghumreddy on March 14, 2007


304. how can we run the batch using command line? Subscribe Asked by: sivanov21Latest Answer: DSJOB Command is the command to run the datastage jobs from command line . in the older architecture... Last Updated By raghumreddy on March 14, 2007


305. what is fact load? Subscribe Asked by: sivanov21Latest Answer: In a star schema there will be facts and dimension tables to load in any datawarehouse environ... Last Updated By raghumreddy on March 14, 2007


306. Does type of partitioning change for SMP and MPP systems? Subscribe Asked by: infinity

Read / Answer307. Explain a specific scenario where we would use range partitioning ? Subscribe Asked by: infinityLatest Answer: If the datais large and if you cannot process the the full data in one time process you will general... Last Updated By raghumreddy on March 14, 2007


308. what is panthom error in data stage Subscribe Asked by: sivanov21Latest Answer: For every job in DataStage, a phantom is generated for the job as well as for every active stage whi... Last Updated By the_xxx on March 19, 2007


309. what is job commit in datastage? Subscribe Asked by: sivanov21Latest Answer: If you see datastage job commits each record in general cases. but you can force the datastage to ta... Last Updated By Raghu Mule on March 14, 2007


310. How do you configure api_dump Subscribe Asked by: prem2129

Read / Answer311. How can we increment the surrogate key value for every insert in to target database Subscribe Asked by: harishthemostwanted

Read / Answer312. How will you pass the parameter to the job schedule if the job is running at night? What happens ifHow will you pass the parameter to the job schedule if the job is running at night? What happens if one job fails in the night?

Subscribe

Asked by: kundanRead / Answer

313. What is the difference between Datastage Server jobs and Datastage Parallel jobs? Subscribe Asked by: GnaneshwarLatest Answer: Basic difference is server job runs on windows platform usually and parallel job runs on unix








































platfo... Last Updated By raju on June 01, 2007 314. What is the difference between Job Control and Job Sequence Subscribe Asked by: vbs19oct

Read / Answer315. Is it possible to calculate a hash total for an EBCDIC file and have the hash total stored as EBCDIIs it possible to calculate a hash total for an EBCDIC file and have the hash total stored as EBCDIC using Datastage?

Subscribe

Currently, the total is converted to ASCII, even tho the individual records are stored as EBCDIC. Asked by: duckcats

Read / Answer316. how to attach a mtr file (MapTrace) via email and the MapTrace is used to record all the execute mahow to attach a mtr file (MapTrace) via email and the MapTrace is used to record all the execute map errors

Subscribe

Asked by: joycemaRead / Answer

317. What is Phantom error in the datastage. How to overcome this error. Subscribe Asked by: madhukerLatest Answer: Phantom Process is Orphened process.Some times some processes will still running in the server even ... Last Updated By Raghu on August 01, 2007


318. How to install and configure DataStage EE on Sun Micro systems multi-processor hardware running theHow to install and configure DataStage EE on Sun Micro systems multi-processor hardware running the Solaris 9 operating system?

Subscribe

Asked by: Kapil JayneRead / Answer

319. How do you load partial data after job failed Subscribe source has 10000 records, Job failed after 5000 records are loaded. This status of the job is abort , Instead of removing 5000 records from target , How can i resume the load Asked by: Hari KishoreLatest Answer: There are lot of ways of doing this.But we keep the Extract , Transform and Load proess seperately.G... Last Updated By Raghu on August 01, 2007


320. What are the important considerations while using join stage instead of lookups. Subscribe Asked by: vijjiLatest Answer: 1. if u need to capture mismatches between the two sources, lookups provide easy option... Last Updated By ajinkyac on June 16, 2007


321. What is Orchestrate options in generic stage, what are the option names. value ? Name of an OrchestWhat is Orchestrate options in generic stage, what are the option names. value ? Name of an Orchestrate operator to call. what are the orchestrate operators available in datastage for AIX environment.

Subscribe

Asked by: srikanthRead / Answer

322. How to implement the type 2 Slowly Changing dimension in DataStage? Subscribe Asked by: VasuLatest Answer: You can use change-capture & change apply stages for this... Last Updated By ajinkyac on June 16, 2007





































323. Is Hashed file an Active or Passive Stage? When will be it useful? Subscribe Asked by: anil kumarLatest Answer: Hash file stage is a Passive stage.The stage which do some process into it is called active stages .... Last Updated By Raghu on August 01, 2007


324. what is the use and advantage of procedure in datastage? Subscribe Asked by: subharatanjenaLatest Answer: To trigger Database operations at before or after DB stage access.... Last Updated By Him121 on June 21, 2007


325. How do you extract job parameters from a file? Subscribe Asked by: MrunaliniLatest Answer: Through user variable activity in sequencer Job. through calling a routine.... Last Updated By shrine on August 01, 2007


326. What is the baseline to implement parition or parallel execution method in datastage job.e.g. more What is the baseline to implement parition or parallel execution method in datastage job.e.g. more than 2 millions records only advised ?

Subscribe

Asked by: epallRead / Answer

327. A batch is running and it is scheduled to run in 5 minutes. But after 10 days the time changes to 1A batch is running and it is scheduled to run in 5 minutes. But after 10 days the time changes to 10 minutes. What type of error is this and how to fix it?

Subscribe

Asked by: subharatanjenaRead / Answer

328. What is Invocation ID? Subscribe Asked by: chetan

Read / Answer329. What is the difference between Squential Stage & Dataset Stage. When do u use them. Subscribe Asked by: rangagopi

Read / Answer330. What is the max size of Data set stage? Subscribe Asked by: rangagopi

Read / Answer331. What are the errors you expereiced with data stage Subscribe Asked by: rangagopi

Read / Answer332. How to connect two stages which do not have any common columns between them? Subscribe Asked by: Praveen

Read / Answer333. In SAP/R3, How do you declare and pass parameters in parallel job . Subscribe Want to convert Char to timestamp in transformer stage. Can anybody please tell me what conversion function I need to put in derivation? Asked by: Sulogna









































data stage faqs

Documents