I am having input--> I want Output like-->
slno|Name slno|Name
1|X 1|X
2|Y 2|X
3|Z 2|X
...

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Sep 12th, 2017

Considering the input data is below. slno|Name 1|X 2|Y 3|Z desired output is slno|Name slno|Name 1|X 1|X 2|Y 2|Y 3|Z 3|Z In the transformer output link add a new column called Na...

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Apr 18th, 2017

Considering the input data is below. slno|Name 1|X 2|Y 3|Z desired output is slno|Name slno|Name 1|X 1|X 2|Y 2|X 3|Z 2|X In the transformer output link add a new column called Name_slno...

Answer Question  Select Best Answer

Input file contains 100 fields, target is
1st field is load into Target 1
2nd field is load into Target 2
3rd field is load into Target3
-----
-----
100th field is load into Target100
How can achieve this scenario ?

Amit Kumar

• Sep 18th, 2018

Step 1: take the columns names in a col_lits.txt file. $head -1 file_name > col_list #IFS="," (say the file was a comma seprated file or if other than , can use tr "other delimiter" ,) for colnm in...

Gurpreet singh

• Apr 5th, 2018

Create 100 target with that one field in DML. Then use a reformat having input file and map each field to target as per requirement.

Answer Question  Select Best Answer

Default cache size is 256 MB. We can incraese it by going into Datastage Administrator and selecting the Tunable Tab and specify the cache size over there. 

Balaji

• Jul 12th, 2007

The default cache size is 128 MB. This is primarily used for hash file data cache in the server.  This setting is only can be done in Administrator not in job level. Job level tuning is available only for Buffer Size.

harshita

• Mar 29th, 2007

Default size is 128mb and we can change cache size in job properties for particular job and by going to tunables in Administrator for all the jobs across project.

Answer Question  Select Best Answer

By using "ExcecSH" command at Before/After job properties. 

anbalag

 Profile Answers by anbalag Questions by anbalag

• May 9th, 2008

You can specify the ExecDos Prompt in the after or before job routine.

vijay

• Nov 3rd, 2007

Select the EDIT tab in the toolbar-> choose job properties-> select the job parameters->choose the Before/ After routines ->select the EXCESH command

Answer Question  Select Best Answer

Config file consists of the following. a) Number of Processes or Nodes. b) Actual Disk Storage Location. 

Venkat Poonati

 Profile Answers by Venkat Poonati Questions by Venkat Poonati

• Mar 29th, 2011

1. fastname-----usually networkname,It is physicall node name,That stages use to open                    ...

aladap12

 Profile Answers by aladap12 Questions by aladap12

• Jun 26th, 2009

Biggest strength of Datastage PX is its configuration file.. Datastage engine learns about size and shape of the system by reading configuration file.It contains Nodes and resource available for running the job.

Answer Question  Select Best Answer

Rekha

• Jul 21st, 2007

* The issue that i faced with datastage is that, it was very difficult to find the errors from the error code since the error table did not specify the reason for the error. And as a fresher i di...

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

1. I feel, the most difficult part is understanding the "Datastage director job log error messages'. It doesn't give u in proper readable message.2.We dont have many date functions availa...

Answer Question  Select Best Answer

qwert123

 Profile Answers by qwert123 Questions by qwert123

• Jun 29th, 2009

Partition the table if there is huge data. This will enhance performance statistics.

satya

• Jul 18th, 2007

You can right click on the server job and select the "view performance statistics" option. This will show the output in the number of rows per second format when the job runs.Regards.Satish.

Answer Question  Select Best Answer

As the names itself suggest what they mean. In general we use Type-30 dynamic Hash files. The Data file has a default size of 2Gb and the overflow file is used if the data exceeds the 2GB size.

klsrao

 Profile Answers by klsrao Questions by klsrao

• Jun 12th, 2007

Good explanation.

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

Dynamic Hash Files can automatically adjust their sie - modulous (no. of groups) and separation (group size) based on the incoming data. Type 30 are dynamic. Static files do not adjust their modulous ...

Answer Question  Select Best Answer

Gnaneshwar

• Apr 9th, 2007

Oracle 8i does not support pseudo column sysdate but 9i supportsOracle 8i we can create 256 columns in a table but in 9i we can upto 1000 columns(fields)

Venkat

• Oct 3rd, 2005

Ramanam.v Wrote: mutliproceesing,databases more dimesnionsal modeling

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Feb 12th, 2008

1. Hashfile can be used as lookup but not the seq file.2. Hashfile works based on Hashed algorithm.3. The performence is more in Hashfile when it is used as a ref link(for lkp)4. we can eliminate dupl...

Sanj333

• Aug 30th, 2007

Hash file can be stored in DS memory (Buffer) but Sequential file cannot be.. duplicates will be removed in hashfile i.e, No duplicates in Hashfile.

Answer Question  Select Best Answer

AjaysKumar

 Profile Answers by AjaysKumar Questions by AjaysKumar

• Jun 4th, 2008

Then you have to manually enter all the column description in each stage.RCP- Runtime column propagation

Venkata Maruthi

• Nov 10th, 2005

Runtime column propagation (RCP): If RCP is enabled for any job, and specifically for those stage whose output connects to the shared container input, then meta data will be propagated at run time, so...

Answer Question  Select Best Answer

?

sekr

 Profile Answers by sekr Questions by sekr

• Apr 14th, 2006

if  ur system is mainfarmes then u can utility called load and unload ..load will load the records into main farme systme from there u hv to export in to your system ( windows)

Sharanu Patil

• Feb 28th, 2006

U can use DB2 stage to implement this

Answer Question  Select Best Answer

mahesh

• Aug 4th, 2011

With NLS enabled, datastage can process data in a wide range of languages & accept data in any character set.

Anwar

• Nov 1st, 2006

NLS is basically Local language setting(characterset) .Once u install the DS u wil get NLS present.Just login into Admin and u can set the NLS of your project based on your project requirement.Just ne...

Answer Question  Select Best Answer

Merge is nothing but a filter conditions that have been used for filter condition

shameerok

• Mar 22nd, 2006

Merge stage is a processing stage, it can have any no of input link and only one output link. It is having master data set and one or more data sets. The out put of the Merge stage is master dataset p...

Sharanu Patil

• Feb 28th, 2006

Merge is maily used to join two flat or sequential files in server jobs

Answer Question  Select Best Answer

machaiyer

• Jul 24th, 2006

open the ODBC Data Source Administrator found in the controlpanel/administrative tools.under the system DSN tab, add the Driver to Microsoft Excel.Then u'll be able to access the XLS file from Datastage.

sivarao

 Profile Answers by sivarao Questions by sivarao

• Dec 28th, 2005

Create a DSN in control panel using microsoft excel drivers.uthen u can read the excel file from ODBC stage.

Answer Question  Select Best Answer

arun

• May 30th, 2006

  if the job have good logic that is called as complex job.simply we can say Scenarios .so If you have faced any complexity while creating job please share with us.  

RamaPrasad Batchu

• Mar 10th, 2006

Complex design means having more joins and more look ups. Then that job design will be called as complex job.We can easily implement any complex design in DataStage by following simple tips in terms o...

Answer Question  Select Best Answer

radha_sreddy

 Profile Answers by radha_sreddy Questions by radha_sreddy

• Sep 13th, 2010

1) Primary Link2) Reference Llink3) Reject Link or Breaking Link

pavan

• Aug 31st, 2006

Two links avilable in datastage 1.primary link 2. reference linkprimary link means:strightly forwarded standard line ________________reference link means:horizentling table------------------------------>

Answer Question  Select Best Answer

sachin

• Nov 21st, 2006

999 MB for reading data into file.999 MB for writing data into file.Thats Approx.2GB for whole Hash File.

BVNREDDY

 Profile Answers by BVNREDDY Questions by BVNREDDY

• Jul 27th, 2006

Max 2 GB for Static hash filenot sure for dynamic

Answer Question  Select Best Answer

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Oct 1st, 2009

Natural key is nothing but primary key, it uses to identify a record uniquly.Surrogate key is to identify a entity uniquly.Regards,Veeru.

sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 14th, 2006

natural key :- seq no system assigned ..skey :- user assigend ! u can start with any number like 100,10001,2002..

Answer Question  Select Best Answer

Bharath narahari

• Dec 5th, 2006

U can also use the sparse look up property when u have large data in the look up table .....

sreenivas

• Jul 31st, 2006

hi,I Have Datastage s/w from this I can work on some job's ...and not on parallel job's............. if i want to work on this, I? need Enterprise Edition S/w or I can implement lookup stage?in serv...

Answer Question  Select Best Answer