nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 16th, 2010

In order to export the jobs you should use datastage manager.In the datastage Manager,go to     Export->Datastage ComponentsThen,select the datastage job that you want to export...

shiva

• Jun 29th, 2006

Hi u have to export .dsx files

Answer Question  Select Best Answer

Alok Ranjan

• Jun 8th, 2006

Someone was saying that join does not support more than two input , while merge support two or more input (one master and one or more update links). I will say, that is highly incomplete information. ...

Unknown

• Jun 8th, 2006

Merge and Join Stage Difference :1. Merge Reject Links are there 2. can take Multiple Update links3. If you used it for comparision , then first matching data will be the output .Because it uses the update links to extend the primary details which are coming from master link

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

Apart from DWH concepts and different stage knowledge,try to use the director to find out errors and also how  to tune the performance.Knowledge of Unix sheel scripting will be very much helpful

kmalla

 Profile Answers by kmalla Questions by kmalla

• Jun 29th, 2006

He should be good at DataWareHousing Concepts and he should be familiar with all stages

Answer Question  Select Best Answer

mcrao1

 Profile Answers by mcrao1 Questions by mcrao1

• Oct 21st, 2010

Control table perform a small verification before running job, Control table will help avoid running query number of times when we are expecting to run single time in a day. Control table contains fields like JOBID,JOB_NAME,PREVIESE_RUN_DATE,

Thank you.
-chalapathirao.m AT hcl DOT com

Guest

• Jul 14th, 2006

Controlling Datstage jobs through some other Datastage jobs. Ex: Consider two Jobs XXX and YYY. The Job YYY can be executed from Job XXX by using Datastage macros in Routines.To Execute one job from o...

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

Just go to th eparticular jobs log

shiva

• Jun 29th, 2006

Using DataStage Director we can find the errors in job sequence

Answer Question  Select Best Answer

aladap12

 Profile Answers by aladap12 Questions by aladap12

• Jun 27th, 2009

When you create hash file, by default in that directory we will have 2 filesdata.30over.30If data has exceed the specified limit, extra data will be written into over.30.
It again depends up on storage capacity.

shiva

• Jun 29th, 2006

It overwrites the file

Answer Question  Select Best Answer

vinothkcet

 Profile Answers by vinothkcet Questions by vinothkcet

• Dec 17th, 2008

There were two collection algorithm 1. Round robin2. Sort/MergeRound Robin :This is the default method. Using the roundrobinmethod the stage will read a row from each input link inturn.Sort/...

Hari

• Jul 27th, 2006

Other than round robin, the other algorithm is Sort/Merge.Using the sort/merge method the stage reads multiple sorted inputs and writes one sorted output. 

Answer Question  Select Best Answer

vasanthsolai

 Profile Answers by vasanthsolai Questions by vasanthsolai

• Mar 17th, 2008

Main difference is routines are return the value , transform are cannot return the value..

laxman

• Jul 18th, 2006

routine and function are sounds same, functions are subset of routines..Routine / Function : taking input data and building some buziness logic and give output dataExamples: StringDecode, KeyMgtG...

Answer Question  Select Best Answer

Vincent

• Sep 19th, 2006

You can see a list of DataStage Certification links and resources at the Squidoo lens: How do I get Websphere DataStage certification?

Suresh Kumar

• Sep 14th, 2006

Thx Shri for your information.Suresh

Answer Question  Select Best Answer

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

debasis

• Nov 13th, 2006

If the problem is only commas in XL file data.. We can open it in Access and save the file with Pipe (|) separator... than can be used as simple sequential file but change the dilimiter to (|).. in the format tab .

laxman

• Oct 24th, 2006

1. Create DSN for your XL file by picking Microsoft Excel Driver2. Take ODBC as source stage3. Configure ODBC with DSN details4. While importing metadata for XL sheet, make sure you should select on system tables check box.Note: In XL sheet the first line should be column names.

Answer Question  Select Best Answer

vsradha

 Profile Answers by vsradha Questions by vsradha

• Jan 26th, 2009

A job with large quantities of data can be partitioned using partition parallelism not with the pipeline parallelism and at end of the job it could be collected and write as a single data source. The...

manraj

• Oct 25th, 2006

consider three cpu connected in series. When data is being fed into the first one,it start processing, simultaneously is being transferred into the second cpu and so on. u can compare with 3...

Answer Question  Select Best Answer

amardeep.reddy

 Profile Answers by amardeep.reddy Questions by amardeep.reddy

• Dec 6th, 2006

A complex flat file can be used to read the data at the intial level. By using CFF, we can read ASCII or EBCDIC (Extended Binary coded Decimal Interchage Code) data. We can select the required columns...

uma

• Oct 30th, 2006

CFF stage is used to read the files in ebcidic format.mainly main frame files with redifines

Answer Question  Select Best Answer

pankaj.garg026

 Profile Answers by pankaj.garg026 Questions by pankaj.garg026

• Jan 15th, 2010

Run Time Column Propagation can be used with Column Import Stage. If RCP is enabled in our project, we can define only the columns which we are interested in and other rest of the columns datastage wi...

poonam

• Feb 14th, 2007

Run time column propagation is used in case of partial schema usage. when we only know about the columns to be processed and we want all other columns to be propagated to target as they are, we check ...

Answer Question  Select Best Answer

What is meant by Lookup Stage?

shri

• Oct 18th, 2011

Lookup stage is similar as join stage,what ever the records from source to target we can use by using lookup, join and in the lookup we have reject link option and join doesn't have reject link option.

j.padma89

 Profile Answers by j.padma89 Questions by j.padma89

• Jul 18th, 2011

Look up stage is used to join dataset which has similar functionality of join stage with some extras.
the difference between join and look up is here
http://www.geekinterview.com/question_details/82179
Hope it helps !

Answer Question  Select Best Answer

How to perform left outer join and right outer join in lookup stage

sivaksa

 Profile Answers by sivaksa Questions by sivaksa

• Aug 13th, 2013

You need right outer join in lookup..please change the link order like left to right, Right to left put lookup failure condition ..continue...

mallika_chaithu

 Profile Answers by mallika_chaithu Questions by mallika_chaithu

• Jun 9th, 2011

In Lookup stage properties, you will have constraints option. If you click on constraints button- you will get options like continue, drop, fail and rejectIf you select the option continue: it means l...

Answer Question  Select Best Answer

What are the different types of constraints ?
Difference b/w unique and not null constraints?

SURESH

• May 6th, 2012

Constraints are used for filter the data as transformer stage and from in sql different type of constrains having null, isnull, primarykey,foreign key and unique constrains Ans unique constrain is not allowed duplicate values and Notnull constrain means should be having a data in that column.

suresh

• May 4th, 2012

Constrain is nothing but it is an condition, it is might be any type of condition. and second one is unique and not null means unique is maintain one record do not accept duplicate record . not null m...

Answer Question  Select Best Answer

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

Raghu

• Aug 1st, 2007

There are lot of ways of doing this.But we keep the Extract , Transform and Load proess seperately.Generally only load job never failes unles there is a data issue.All data issues are cleared bef...

Answer Question  Select Best Answer

csri2006

 Profile Answers by csri2006 Questions by csri2006

• Jan 31st, 2008

In what database is the stored procedure located. If it is Oracle stored procedure, you can use "stored procedure stage" in DataStage 7.5.Hope this helps. Srinivas

Answer Question  Select Best Answer

nagakalyan

 Profile Answers by nagakalyan Questions by nagakalyan

• Jun 23rd, 2008

Lookup we can set condition option otherwise then reject records enter into target we can direct load data what ever it may be load and create

Answer Question  Select Best Answer