CoolInterview.com - World's Largest Collection of Interview Questions
Interview Success Kit - 9,000 Interview Que. & Ans.
Covers 9,000+ Interview Questions asked in actual MNC Interviews - all with model answers.
Start Your Own website Now
Sponsored Links

Interview Questions
Our Services


INTERVIEW QUESTIONS DATA WAREHOUSING DATASTAGE DETAILS
Question :
How 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.


Category DataStage Interview Questions
Rating (0.3) By 22 users
Added on 7/26/2011
Views 472
Rate it!
Answers:

You need to configure the ODBC connectivity for database (DB2 or AS400) in the datastage.



If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-

  • There should not be any Spelling Mistakes.
  • There should not be any Gramatical Errors.
  • Answers must not contain any bad words.
  • Answers should not be the repeat of same answer, already approved.
  • Answer should be complete in itself.
  • Name :*
    Email Id :*
    Answer :*
    Verification Code Code Image - Please contact webmaster if you have problems seeing this image code Not readable? Load New Code
    Process Verification  Enter the above shown code:*
    Inform me about updated answers to this question

       
    Related Questions
    View Answer
    What is the OCI? and how to use the ETL Tools?

    View Answer
    What 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 ?


    View Answer
    What is APT_CONFIG in datastage

    View Answer
    How we use NLS function in Datastage? what are advantages of NLS function? where we can use that one? explain briefly?

    View Answer
    What is merge ?and how to use merge?

    View Answer
    What is difference between serverjobs & paraller jobs

    View Answer
    How can ETL excel file to Datamart?

    View Answer
    what 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?

    View Answer
    What 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 parallel

    3)Tuning should occur on a job-by-job basis. Use the power of DBMS.


    View Answer
    How to implement routines in data stage,have any one has any material for data stage pl send to me

    View Answer
    How can u implement slowly changed dimensions in datastage? explain?

    2) can u join flat file and database in datastage?how?

    View Answer
    How can you implement Complex Jobs in datastage

    View Answer
    Does Enterprise Edition only add the parallel processing for better performance?

    Are any stages/transformations available in the enterprise edition only?

    View Answer
    How can you do incremental load in datastage?

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

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

    View Answer
    What is the difference between Datastage and Datastage TX?




    View Answer
    What 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


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

    View Answer
    Can we use shared container as lookup in datastage server jobs?

    View Answer

    Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

    View ALL DataStage Interview Questions

    User Options
    Latest 20 Questions
    what is business process service? explain
    what is business process service? explain
    why we use normal brain in object identification when we have smart brain?
    what should the 64-bit integer type on new,64-bit machines be?
    What is the meaning Of Accounting
    How can u create apache log files with name as date?(means every day it has to create new log file with name as date) not by any scripts..
    How can u schedule a job using cron for 20 secs?
    Find about the weight and measure used in past?
    What is the difference between filter and condition? clear definition?
    How to write functions in c program without using headerfile.
    What is the script for retrieving data which is of string type from excel sheet.
    what are the interview questions in unix through informatica?
    1)what are all Unix commands we are using in informatica?
    How to pass multiple tables in datasets simultaneously?
    How abstraction done in C?
    you don't have enough experience, in fact you were ideal for one year, give any one reason to select you in our prestigious institution for the course of mba
    what do they mean by account payable
    'Describe for me a situation where you were required to gather a large amount of data, to analyse it objectively and to make a decision or a recommendation based on the results.'
    Can we add different work flows in to one batch and run sequentially? If pos how do we do that?
    what is studs and test drivers? it is related to testing?


    Copyright ©2003-2016 CoolInterview.com, All Rights Reserved.
    Privacy Policy | Terms and Conditions

    Download Yahoo Messenger | Placement Papers| FREE SMS | ASP .Net Tutorial | Web Hosting | Dedicated Servers | C Interview Questions & Answers

    Testing Articles | Testing Books | Testing Certifications | Testing FAQs | Testing Downloads | Testing Interview Questions | Testing Jobs | Testing Training Institutes


    Cache = 0 Seconds