DB Architecture interview questions

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

How we can secure our data in local area Network

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

1.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

How 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 cou

My 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

How 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

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.

What other ETLs you have worked with?

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

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

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

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.

What happends out put of hash file is connected to transformer ..What error it throughs

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

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

How to sort the data in Datagrid ? when we use DataBound event of Datagrid, I want to display te data using controls....For an example, If i click a button, which is outside of the datagrid, entire data should be shown. 1st column in TextBoxs. second colu

Consider a sales invoice and the programmer has to save multiple items in one sales invoice. On entering the rate and qty, the amount and total amount should be automatically calculated. The invoice number will be the same for all items in that invoice. I

I wanted to load only particular no of records suppose i have 100 records out of which i wanted to load first 10 records to target.

What is data validation strategies for data mart

Define data flow diagram.

What is the difference between Generate Records Component and Create Data Component?

How to restrict up to three levels in hierarchy when u dodrill mode?

Explain about Control M JObs detaily?How to execute this.

Hi This is VijayHow Can u Read the data from sequential file Parall'y?

Tell me one example for multi valued dimension or bridge table?

Sample code to read a 2nd record from last in flatfile howcan we do it?

What is rcp,if rcp disabled what happen?

How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

I want to get sales data for the last (suppose 10) dates dynamicallyusing value prompt how can i do it and drag it onto report editor.