DataStage Interview Questions

Feb 28 2007

11:50 AM

2828
Views

2
Ans

What is job commit in datastage?

sivanov21
DataStage Interview Questions

Raghu Mule

Mar 14th, 2007

If you see datastage job commits each record in general cases. but you can force the datastage to take a set of records and then commit them.In case of Oracle stage in Trasaction Handling Tab you can set the number of rows per transaction. HTH.Raghu Mule

kumar

Mar 6th, 2007

job commit means it saves the changes made

Answer Question Select Best Answer

Oct 14 2006

05:38 AM

4253
Views

2
Ans

Hi..Disadvantages of staging area Thanks,Jagan

Jagan
DataStage Interview Questions

RAVI

Mar 2nd, 2007

Yes, its like a disadvantage of staging area, it takes more space in database and it may not be cost effective for client.

debasis_mohanty
Profile Answers by debasis_mohanty Questions by debasis_mohanty

Oct 17th, 2006

Hi JaganI think disadvantage of staging are is disk space as we have to dump data into a local area.. As per my knowledge concern, there is no other disadvantages of staging area.- Debasis

Answer Question Select Best Answer

Feb 07 2007

09:26 AM

2383
Views

1
Ans

What is the difference between RELEASE THE JOB and KILL THE JOB?

sivanov21
DataStage Interview Questions

deepa

Feb 26th, 2007

HiRelease the job is to release the job from any dependencies and run it.Kill the job means kill the job that's currently running or scheduled to run.

Answer Question Select Best Answer

Apr 24 2006

04:55 PM

2361
Views

1
Ans

Can you convert a snow flake schema into star schema?

dwandbi
DataStage Interview Questions

Yes, We can convert by attaching one hierarchy to lowest level of another hierarchy.

katta

Feb 24th, 2007

No. It is not possible

Answer Question Select Best Answer

Feb 07 2007

09:31 AM

4239
Views

2
Ans

What is repository?

sivanov21
DataStage Interview Questions

prasad

Feb 23rd, 2007

Repository is a content which is having all metadata (information).

veeru_veeru

Feb 13th, 2007

Repository resides in a spcified data base. it holds all the meta data, rawdata, mapping information and all the respective mapping information.

Thanks,
Veeru.

Answer Question Select Best Answer

Jan 17 2007

04:10 PM

2739
Views

2
Ans

What is Fact loading, how to do it?

Prashant Narayani
DataStage Interview Questions

Amjad

Feb 23rd, 2007

Once we have loaded our dimensions, then as per business requirements we identify the facts(columns or measures on which business is measured) and then load into fact tables..

vijay

Jan 22nd, 2007

firstly u have to run the hash-jobs, secondly dimensional jobs and lastly fact jobs.If any quries just mail tome

Answer Question Select Best Answer

Oct 17 2006

11:42 AM

6552
Views

2
Ans

What for we use Hashed files in datastage job? Give an example

Lakshmi Kumar
DataStage Interview Questions

noverino
Profile Answers by noverino Questions by noverino

Feb 23rd, 2007

I'm agree with naveen patil, Hashed file is used for lookup process. Beside that, Hashed file can also be used if we want to get Distinct data from a source by using the column as key. Sample, I w...

naveen patil

Nov 28th, 2006

Mainly hased files are used for lookup perpose. for example ur looking for the data whether the entry is their or not. if it is thr do something otherwise something else

Answer Question Select Best Answer

Feb 23 2007

02:18 AM

2526
Views

0
Ans

How is design (Fact and Dimension) of Fact Table Type 2 (keep historical value)

Answer Question

Dec 04 2006

06:01 AM

2340
Views

2
Ans

What is the alternative way where we can do job control??

Vennela17

Feb 22nd, 2007

Jobcontrol can be done using :Datastage job SequencersDatastage Custom routinesScriptingScheduling tools like Autosys

Naga

Dec 12th, 2006

Hi, Job Control will possble Through scripting. Controling is dependent on Reqirements.need of the job.

Answer Question Select Best Answer

Jan 28 2007

07:40 PM

2760
Views

1
Ans

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 ?

Vennela217

Feb 22nd, 2007

Hi,You can use Link partitioner and link collector stages in server jobs to speed up processing.Suppose you have a source and target and a transformer in between that does some processing, applying fn...

Answer Question Select Best Answer

Nov 16 2006

03:59 PM

7368
Views

2
Ans

Where can you output data using the Peek Stage?

karthik

Feb 21st, 2007

The output of peek stage can be viewed in director LOG and also it can be saved as a seperate text file?

asa

Nov 20th, 2006

In datastage Director!Look at the datastage director LOg

Answer Question Select Best Answer

Dec 14 2006

01:15 PM

3498
Views

1
Ans

How can i handle the after job subroutine in the transformer stage?

suganya
DataStage Interview Questions

Sathish123
Profile Answers by Sathish123 Questions by Sathish123

Feb 20th, 2007

In Transformer Stage click on properities tab in tool bar(Left corner tab). It displays stage properities page like all the other job properities page. There you can specify your before after stage subroutins.

Answer Question Select Best Answer

Sep 23 2006

07:22 AM

4189
Views

4
Ans

1.What is the use of parameters in datastage job?2.What is the difference between datastage 6 and datasttage 7.0?3.Whta is unit testing, system testing and integration testing?4.seheduling the jobs in Datastage?5.What is the difference between datastage 7.1 and datasttage 7.5?6.How to do error handling in datastage?7.how do you remove duplicates in a flatfile?

srinivas
DataStage Interview Questions

Sathish123
Profile Answers by Sathish123 Questions by Sathish123

Feb 20th, 2007

The main purpose of job parameters in Datastage is to provide the values at job run time.Ex;File Path,File name,database server name,userid,password.

naveen patil

Nov 28th, 2006

Parameters are helps to enter values at run time. and also makes secure by not to forcing a hard coding.Unit testing is the one mainly deals with a single job.system testing is the one deals wit...

Answer Question Select Best Answer

Feb 07 2007

09:38 AM

2517
Views

1
Ans

What is the difference between datasatge and datastage TX?

sivanov21
DataStage Interview Questions

veeru_veeru

Feb 13th, 2007

Hi, WebSphere Transformation Extender (WTX) is the universal transformation engine for WebSphere that addresses these complex data challenges to integration. Through its unique ability to speak to an...

Answer Question Select Best Answer

Sep 13 2006

03:17 PM

9825
Views

1
Ans

1 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 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 improve the performance of DataStage jobs?.11 11.How can we create Containers?.12 12.What about System variables?.13 13 What is the use of Usage analysis ?14 14 Different ways a project can be moved to production ?...example �.export-import and Version control.15 15 What database is the Datastage repository use �? Answer: Universe Database16 16 How is the scheduling done in the project ?17 17 Which version of DataStage is used in the project?18 18 What are the performance tuning required while dealing with large data ?19 19 What do the reject option in transformer do? 20 What is the architecture of datastage?21 How do you define and use the job parameters?22 What is stage variables,system variables,environment varaibles?23 How to use routines in datastage?24 What is difference between shared-container and local-container?25 How do you connect to Oracle?26 Please explain any ETL process that you have developed?27 What is hash file? Types of hash files.28 If you are doing any changes in shared-container will it reflect in all the jobs wherever you used this shared- container?29 Have u written any custom routines in your project? If so explain?30 How do you get log info into a file?31 What is before job subroutine/After job subroutine? When do you use them?32 How do you backup and restore the project? 33 What is Clear Status File and when do you use it? 34 What is Cleanup Resources and when do you use it?35 Can I join a flat file and oracle and load into oracle? Is this possible?36 While loading some data into target suddenly thier is a problem loading process stopped how can u start loading from the records that were left?37 What are the general problems that u face in Datastage?38 What are the various reports that could be generated using this Datastage?39 How to remove blank spaces from data40 What is Active and Passive stage?41 What all are the stages you have used in your project?42 Could DataStage generate test cases?43 What is difference between hash file and sequential file44 What is the difference between Transform and routine45 What is sequencer?46 How to take backup of project?These are some of DataStage PX Jobs questions which can be asked in interviews.1) Types of parallel processing2) What is the SMP(Symmetric MultiProcessing) and MPP (Masiively parallel processing)?3) What is CPU limited , Memory limited and Disk I/O limited jobs ?4) Can one combine pipeline & partition parallelism?5) Advantages of PX over server job6) Is it possible to create user-defined stage in PX?7) Can I use hash file in PX?8) What is surrogate key stage?1) What is the use of APT_DUMP_SCORE ? Ans: To get messages in logs such as no of processes, no of nodes used.2) What are the fours types of joins possible in Joiner stage? Ans: Inner, Left Outer, Right Outer, Full outer3) What are the components of APT_CONFIG_FILE Ans: Nodes, Fastnode, Pools, ResourceWhat are the points that needs to be considred while creating the config file? Ans: Available nodes, CPU time, available memory, what other process to be executed on same nodes, are there any configurations restrictions ? Eg DB only runs on certain nodes and ETL cannot run on them, Get breakdown of the resource usage? Is the hardware config SMP, Cluster or MPP?5) When are wrappers created? Ans:only for executable commands for unix, dos6) When are buildups created? Ans: More functionality, complex logic needed.7) When are custom stage created ? .. Ans :new operators need which are not in EE 8) What are different job sequencer stages ?9) What is iconv and oconv functions?.10) can we implement Slowly Changing Dimensions in DataStage?. what are the Job parameters?.9. Plug-in?.10.How can we improve the performance of DataStage jobs?.11.How can we create Containers?.12.What about System variables?.13 What is the use of Usage analysis ?14 Different ways a project can be moved to production ?...example �.export-import and Version control.15 What database is the Datastage repository use �? Answer: Universe Database16 How is the scheduling done in the project ?17 Which version of DataStage is used in the project?18 What are the performance tuning required while dealing with large data ?19 What do the reject option in transformer do? 20) How is parallelism executed?21) What is RCP?22) What is orchestrate23) Difference between join, merge, and lookup stage?24) What is dataset ? 25) Diffrenece between dataset, fileset and lookup file set?Questions on Data Warehousing concept 1. What is Data Warehouse?2. What is difference between Data Warehouse and Data Mart ?3. What is Star schema?4. What is Snow-flake schema?5. What is fact and dimension?6. What is surrogate key?7. What Normlisation ?Explain 3rd Normlised form?8. What is the difference between OLTP and OLAP?9. Are you involved in data modeling ?If yes which tool/tech you are using?10. Which schema modeling techniques you ever used?11. What do you mean by summary table?12. What Degenerated Dimensions13. What is fact less fact?Oracle question based on data warehouse?1 What is parallel execution2 What is Bitmap and B-Tree indexes ? Explain Local Vs Global variables3 What is materialised view4 What is page size/array size in oracle?5 What are integrity constraints ?6 How can one tune SQL�s in Oracle?

Zias
DataStage Interview Questions

Vinod

Feb 13th, 2007

The records in a Sequential file are organized serially, one after another, but the records in the file may be ordered or unordered. The hashed file access method scatters the records randomly through...

Answer Question Select Best Answer

Dec 29 2006

11:59 AM

2011
Views

2
Ans

sample:

Cola Colb Colc
1 10 100
2 20 200
3 30 300
Assume: cola is primary key
How will you fetch the record with maximum cola value using data stage tool into the target system">

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

Waseem
DataStage Interview Questions

someone

Feb 6th, 2007

Aggregator Stage

Guest

Jan 12th, 2007

Hi As per the question it is very clear that the source data is in Tableyou can use oci stage to read the source filein the oci Stage write user defined sql query as " Select Max(cola) from the table"...

Answer Question Select Best Answer

Jun 22 2006

09:53 AM

2065
Views

3
Ans

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

K.Bala Subrahmanyam
DataStage Interview Questions

prassy

Feb 5th, 2007

U can Parameterize using #parameter-name#... and define the parameter in the job properties..

shiva

Jun 29th, 2006

#FILENAME#

Answer Question Select Best Answer

Jan 31 2007

02:26 AM

2335
Views

1
Ans

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 ?

veera_123

Feb 1st, 2007

Hi,WebSphere? Transformation Extender (WTX) is the universal transformation engine for WebSphere that addresses these complex data challenges to integration. Through its unique ability to speak to and...

Answer Question Select Best Answer

Jan 21 2007

11:41 PM

3817
Views

0
Ans

Hi, I would like to know the future prospects of DataStage - IBM. I want to know about the career and opportunities of this in the current IT market scenario. will this be hot at least for the next two years? Please advice me in choosing this and also plz mention the hourly billing for DataStage.Regards,Abhinav

abhinav
DataStage Interview Questions

Answer Question

Jan 03 2007

10:23 AM

1956
Views

1
Ans

How to run a job using command line?

Prashant Narayani
DataStage Interview Questions

ram

Jan 7th, 2007

Dsjob -run -jobstatus projectname jobname

Answer Question Select Best Answer

Login

What is job commit in datastage?

Raghu Mule

kumar

Hi..Disadvantages of staging area Thanks,Jagan

RAVI

debasis_mohanty

What is the difference between RELEASE THE JOB and KILL THE JOB?

deepa

Can you convert a snow flake schema into star schema?

katta

What is repository?

prasad

veeru_veeru

What is Fact loading, how to do it?

Amjad

vijay

What for we use Hashed files in datastage job? Give an example

noverino

naveen patil

How is design (Fact and Dimension) of Fact Table Type 2 (keep historical value)

What is the alternative way where we can do job control??

Vennela17

Naga

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 ?

Vennela217

Where can you output data using the Peek Stage?

karthik

asa

How can i handle the after job subroutine in the transformer stage?

Sathish123

Sathish123

naveen patil

What is the difference between datasatge and datastage TX?

veeru_veeru

Vinod

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

someone

Guest

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

prassy

shiva

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 ?

veera_123

How to run a job using command line?

ram

Latest News

It looks like you are using an AD Blocker!