We are using below command in Unix to run a Datastage Job:
dsjob run mode project_name job_name
When we are executing the above command in Unix what exactly it returns?

Aloka

 Profile Answers by Aloka Questions by Aloka

• Aug 8th, 2016

Hi,
May be a question for reviewers who wanted to know more on this.You can leave it.
Thanks !

Ram

• Aug 4th, 2016

Hi,
is it question for reviewers or your doubt ?
you got answer if you run the command.

Thanks !

Answer Question  Select Best Answer

I have a job with 2 parameters sets, I added new parameters sets, is it necessary to compile the job or not?

Karthik

• May 26th, 2017

Yes the jobs needs to be compiled whenever we are making changes to Parameter Set

Amruta

• Aug 1st, 2016

Yes..The DS job needs to be compiled after adding new parameter sets.

Answer Question  Select Best Answer

I have a file having columns C1,C2,C3,C4,C5 with comma delimited.In target I want store the first two columns value into one column.

Like below

Input Output I need
-------------- ----------------------
C1 C2 C3 C4 C5 C1(C1 & C2 value) C3 C4 C5

That means my input is 5 columns & Output will be 4 columns.
Can...

Chikka

• Aug 27th, 2016

Create a new stage variable and using concatenation operator combine first two columns data and map it to a column.

subbu

• Aug 26th, 2016

You can try using copy & tx stages

Answer Question  Select Best Answer

Can we implement SCD stage using Lookup stage? If Yes then how?

Neha

• Feb 21st, 2017

We can Perform SCD using lookup stage and Change Capture stage depending upon the type of SCD.

vibgyss

• Oct 7th, 2016

Yes, We can impliment SCD by Lookup stage

Answer Question  Select Best Answer

While implementing SCD, there are two output links updating data to same table. One link for insert and one link for update. How it is possible? Will it not result a write lock on a table if two links accessing same table for writing?

Ammu

• Mar 30th, 2017

Thanks for the answer

sri

• Mar 27th, 2017

Table level lock applies only when we explicitly define during table creation. In the case you mentioned to update and insert, there will be row level lock implies on that table. Logically, Insert re...

Answer Question  Select Best Answer

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

Data in a Database is a) Detailed or Transactional b) Both Readable and Writable. c) Current.

bhargava

• May 1st, 2007

Database data is in the form of OLTP and Data warehouse data will be in the form of OLAP. OLTP is for transactional process and OLAP is for Analysis purpose.

Ravi B

• Mar 30th, 2005

By Database, one means OLTP (On Line Transaction Processing). This can be the source systems or the ODS (Operational Data Store), which contains the transactional data.

Answer Question  Select Best Answer

In a Hashed File, the size of the file keeps changing randomly. If the size of the file increases it is called as "Modulus". If the size of the file decreases it is called as "Splitting". 

Santhosh_DataStage

 Profile Answers by Santhosh_DataStage Questions by Santhosh_DataStage

• Dec 2nd, 2009

Modulo is the calculated value which is calculated by using a Hash File Calculator. It tells the optimal number of groups to be created in the hash file to use it effectively. The Input to this Modulo calculation are the approximate number of records and the width of each record.

Milestones

• Sep 22nd, 2005

The modulus size can be increased by contacting your Unix Admin.

Answer Question  Select Best Answer

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

You can insert the parameter values in a table and read them when the package runs using ODBC Stage or Plug-In stage and use DS variables to assign them in the data pipeline, or pass the par...

malneedi

 Profile Answers by malneedi Questions by malneedi

• Sep 29th, 2005

Two ways1. Ste the default values of Parameters in the Job Sequencer and map these parameters to job.2. Run the job in the sequencer using dsjobs utility where we can specify the values to be taken for each parameter.

Answer Question  Select Best Answer

100+ jobs for every 6 months if you are in Development, if you are in testing 40 jobs for every 6 months although it need not be the same number for everybody

Prakash3366

 Profile Answers by Prakash3366 Questions by Prakash3366

• Jun 17th, 2009

Depends on which type of project you are working. Sometimes in Parallel Jobs we will take more time to finish complex job. If you have 3 years experience then you have to tell more than 100 Jobs, Few jobs in server and few in parallel

Anjan Roy

• Sep 16th, 2005

- I don't think these are the right numbers. Someone creating 100+ jobs in 6 months !! If you do the math - it would be 6 Months = 6 months * 22 Days * 8 Hours  = 1056 hours. The above state...

Answer Question  Select Best Answer

Goutham

 Profile Answers by Goutham Questions by Goutham

• Jan 26th, 2006

It is used to view and edit the contents of datastage repository.

prashanth

• Aug 25th, 2005

Datastage maneger is used to export and import purpose [/B] main use of export and import is sharing the jobs and projects one project to other project.  

Answer Question  Select Best Answer

hanug

 Profile Answers by hanug Questions by hanug

• May 7th, 2007

It is primarily used to create the Datastage project, assign the user roles to the project, set parameters of the jobs at project level. Assign the users to the project can also be done here.Hanu.

CNU

• Aug 2nd, 2005

The Administrator enables you to set up DataStage users, control the purging of the Repository, and, if National Language Support (NLS) is enabled, install and manage maps and locales. 

Answer Question  Select Best Answer

Informatica and also DataJunction if it is present in your Resume.

mahesh4346

 Profile Answers by mahesh4346 Questions by mahesh4346

• Feb 29th, 2008

ETL tools are1) Informatica by Informatica Corporation2) Datastage by IBM3) Ab initio by Ab initio software Corporation4) Data Junction by Pervasive software 5) Oracle Warehouse Builder by Oracle Corp...

sekr

 Profile Answers by sekr Questions by sekr

• Dec 10th, 2005

ab-initiodatasatge EE parllel editionoracle -Etlthere are 7 ETL in market !

Answer Question  Select Best Answer

On the scale of 1-10 say 8.5-9 

padmanabhan.s

 Profile Answers by padmanabhan.s Questions by padmanabhan.s

• Jul 29th, 2008

Though we dont write the PL/SQL directly, we can write a procedure or a fucntion which determines our needs and then can be called in the datastage ODBC or OCI stage using call() statement. For eg. if...

sekr

 Profile Answers by sekr Questions by sekr

• Jan 31st, 2006

U will not be writtinf pl/sql in datastage ! sql knowledge is enough ...

Answer Question  Select Best Answer

vijay

• Nov 4th, 2007

 by using lookup stage and change capture stage we will implement the  scd.   we have 3 types of scds   type1:it will maintain the current values only.   type2:...

suganyasug

• Apr 18th, 2007

We can implement SCD in datastage 1.Type 1 SCD:insert else update in ODBC stage2.Type 2 SCD:insert new rows if the primary key is same and update with effective from date as JobRundate and to date to ...

Answer Question  Select Best Answer

lakshmib

 Profile Answers by lakshmib Questions by lakshmib

• Sep 24th, 2008

It is a runtime parameter which allows you to enter the value to restrict the data at the job run time. A job parameter is created with name,promt,data type,default value,and it is reprsented as follows #parameter name#.

mallakishore

 Profile Answers by mallakishore Questions by mallakishore

• Oct 20th, 2005

These Parameters are used to provide Administrative access and change run time values of the job.EDIT>JOBPARAMETERSIn that Parameters Tab we can define the name,prompt,type,value

Answer Question  Select Best Answer

satish kumar

• Apr 16th, 2006

hicontainers r speacial type of jobs in the datastage that will simplify the job design either in the server or parallel jobs.2 types of containers1.Local containers2 shared containers   Loc...

mallakishore

 Profile Answers by mallakishore Questions by mallakishore

• Oct 20th, 2005

There are Two types of containers1.Local Container2.Shared ContainerLocal container is available for that particular Job only.Where as Shared Containers can be used any where in the project.Local cont...

Answer Question  Select Best Answer

qwert123

 Profile Answers by qwert123 Questions by qwert123

• Jun 30th, 2009

Automation of loading is supported partly in Informatica so third party tools are needed to achieve this, while data stage supports automation of loading fully.

Jimmy

• Sep 11th, 2005

Here is a very good articles on these differences... whic hhelps to get an idea.. basically it's depends on what you are tring to accomplishwhat are the requirements for your ETL tool? Do you have lar...

Answer Question  Select Best Answer

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 10th, 2007

There is a lock for update option in Hashed File Stage, which locks the hashed file for updating when the search key in the lookup is not found.

Sharanu Patil

• Feb 28th, 2006

Question is not clear still, i think 'insert to update' is updated value is inserted to maintain  history

Answer Question  Select Best Answer