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

mcrao1

 Profile Answers by mcrao1 Questions by mcrao1

• Jun 4th, 2012

DataStage Job run from Unix Command Line I am running DataStage Job from Unix Command Line with job level parameters the job is getting abort , can someone correct if there is any syntax problem in t...

Pavan

• Aug 29th, 2005

We can call Datastage Batch Job from Command prompt using 'dsjob'. We can also pass all the parameters from command prompt. Then call this shell script in any of the market available schedulers. The 2nd option is schedule these jobs using Data Stage director.

Answer Question  Select Best Answer

Seio

• Feb 25th, 2012

I'm interested in this answer because for any reason my jobs appear not compile after I begin the execution and I need an automatic process that auto compile the jobs when it founds uncompiled.

Thanks.

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 19th, 2010

If the job failed to compile, there must be some problem with the job.If the problem is not fixed then no matter how many times it is recompiled, the compilation will fail each time.Automatic recompile?option does not seem to be there in datastage.

Answer Question  Select Best Answer

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 20th, 2007

Transformer stage to identify and remove duplicates from one output, and direct all input rows to another output (the "rejects"). This approach requires sorted input.

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 20th, 2007

This is questions has got more answers as the elimination od duplicates are situation specific. Depending upon the siutation we can use the best choice to remove duplicates.1. Can write a SQL qurey de...

Answer Question  Select Best Answer

wahi80

 Profile Answers by wahi80 Questions by wahi80

• Feb 20th, 2008

Surrogate key generator is available only in Parralle edition in Server mode you will have  to use stage variables or pre-defined variables like @inrownum, @outrownum

Abhijain

 Profile Answers by Abhijain Questions by Abhijain

• Feb 20th, 2008

It can be used through the Surrogate key generator stage of the datastage.

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

In a star schema there will be facts and dimension tables to load  in any datawarehouse environments. You will generaly load the Dimension tables first and then Facts.Facts will have the relative information of dimension.HTHThanksRaghu Mule

Ramesh Chandra yadav

• Mar 9th, 2007

You load the facts table in the data mart with the combined input of ODBC (OR DSE engine) data sources. You also create transformation logic to redirect output to an alternate target, the REJECTS table, using a row constraint.

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

Enviroment Variables are the one who set the enviroments.Oce you set these varicables in datastage you can use them in any job as a perameter.Example is you you want to connect to database you need us...

kumar

• Mar 6th, 2007

Environment variables are predefined variable those we can use while creating datastage jobs.We can set in project level or job level once we set the variable the variable will be available in the project.

Answer Question  Select Best Answer

raghumreddy

• Mar 14th, 2007

If the datais large and if you cannot process the the full data in one time process you will generally use the Range partitioning.HTHThanksRaghu Mule

uk5673

• Mar 5th, 2007

It is used when Data Volumn Is high.It's Partitioning by Column wise.

Answer Question  Select Best Answer

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