How to unlock a job in Datastage 8.0?

sivakumar.datastagepx

 Profile Answers by sivakumar.datastagepx Questions by sivakumar.datastagepx

• Jan 19th, 2011

$ps -EF$kill PIDBy using above 2 commands in unix ...then we can kill the jobotherwise tools-> cleanup resourses

svasu.r

 Profile Answers by svasu.r Questions by svasu.r

• Aug 14th, 2010

If you want unlock the jobDS DIRECTOR----------->JOB TAB-------->Clean up on resourcesIn admin enable priviliges to director

Answer Question  Select Best Answer

What various validations do you perform on the data after extraction?

varunndschange

 Profile Answers by varunndschange Questions by varunndschange

• Aug 13th, 2010

In data validation we check for the data size, data type, removing extra spaces and applying proper null handling.

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Aug 13th, 2010

It depends upon the requirment you needed.Some bascic checks:1. NULL validation2. Data type validationif you consider Data quality below points may come across1. Address fileld validations2. Word validations3. Character validations

Answer Question  Select Best Answer

Does flatfile contain header & footer?How to remove Header & Footer from a flatfile before extracting the data?What information header & footer contains?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Nov 30th, 2010

Does flatfile contain header & footer? =>Yes, it may or may not contain header or footer depending on the requirements. How to remove Header & Footer from a flatfile before extracting t...

Brajesh Singh Bhadoriya

 Profile Answers by Brajesh Singh Bhadoriya Questions by Brajesh Singh Bhadoriya

• Sep 20th, 2010

A Flat file can have header and trailor. These will contain the information about the file. For example, header will have date for which the file is, and trailor will have records count. this count ma...

Answer Question  Select Best Answer

What is invocation Id? How to find InvoicationID? What is the need of Invocation Id?

tapan8984

 Profile Answers by tapan8984 Questions by tapan8984

• Aug 12th, 2011

Invocation ID is the unique identifier for distinguishing the instances in multiple instance job. It is needed for uniquely define the instances. While running the job there is a field for Invocation ID in the run window (pop-up).

narra satish

 Profile Answers by narra satish Questions by narra satish

• Mar 7th, 2011

Invocation id is nothing about instance. Normaly job run in only one instance.By enabling it will run in multiple instance. As long as running invocation Id is unique.

Answer Question  Select Best Answer

How can we improve performance using copy stage

Datastage Etl

 Profile Answers by Datastage Etl Questions by Datastage Etl

• May 13th, 2011

Copy stage is used to send the data to the multiple sources.?Here we can ?change the column names . Rather than using Transformer Stage where ever necessary , we can use the copy stage. Like this, c...

narra satish

 Profile Answers by narra satish Questions by narra satish

• Mar 21st, 2011

By using copy stage we can increase the performance. In this stage we can do sorting, Removing unwanted columns

Answer Question  Select Best Answer

TABLE T1 with c1 and Table T2 with c1
1 3
2 4
2 5
3
4
5
...

sivaksa

 Profile Answers by sivaksa Questions by sivaksa

• Aug 13th, 2013

Yes ?A is the correct ?answer

Dinesh

• Aug 19th, 2011

Use lookup stage...and choose reject option !
you will get the matched records in master output file(3,4,5,5) and unmatched in reject file(1,2,2,6,7).

Answer Question  Select Best Answer

I can only see the name of the stage variables but cannot see the definition, where can I find them?

manish_toy

 Profile Answers by manish_toy Questions by manish_toy

• Jan 10th, 2012

If you are not able to view the definition then its has not been given. You have to provide the definition by double clicking to the left of the variable and give the definition as per your requirement.

manish_toy

 Profile Answers by manish_toy Questions by manish_toy

• Jan 10th, 2012

If it is not visible in the transformer stage then the definition has not been given. You have to provide the definition for the stage variable by double clicking to the left of the variable, then you can give the definition as per your requirement.

Answer Question  Select Best Answer

Sushil

• Aug 19th, 2013

Basically Environment variable is predefined variable those we can use while creating DS job.We can set either as Project level or Job level.Once we set specific variable that variable will be available into the project/job

glaciya

 Profile Answers by glaciya Questions by glaciya

• Dec 12th, 2011

The Environmental variables in datastage are some pathes which can support system can use as shortcuts to fulfill the program running instead of doing nonsense activity. In most time, environmental variables are defined when the software have been installed or being installed.

Answer Question  Select Best Answer

How do we know the no of processors in a job? Is there any specific calculation for this.

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

There will not be any processors in the job. Your question could be - find the number of nodes/processors on which the job is running. So the answer to this - go to Director and open the log for the ...

Kumaresh

• Jul 19th, 2013

Run the job. Go to director log. Check for the apt config data displayed over there. That will show the number of processors/nodes.

Answer Question  Select Best Answer

Please answer this question

santosh varma

• Mar 21st, 2013

Your database size is the sum of all datafiles,tempfiles,redologs. so check the sum from dba_data_files,dba_temp_files and v$logfile

Harikrishna Chidrala

• Mar 15th, 2013

It Depends about the size,Example My Development Database size is 6TB and UAT Server is 12 TB and Production is ~25TB.

Answer Question  Select Best Answer

Hi,
Job1 is running for 10 minutes for the first time and the same job1 is running for 15 minutes for the second time ,the load being the same for both.Could someone explain..

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

One reason could be that - for the first time the job is just loading/inserting data into target. When you run the same job again, it would take more time as it tries to update from second time. Upda...

Raju Nath

• Jun 27th, 2013

Hi you can use the delete and then load command during loading then it will be the same time. First time when you are loading that time the dataset/table is empty that is why its taking less time bu...

Answer Question  Select Best Answer

Ishu

• Feb 20th, 2015

Use of parameters: 1. avoid hardcoding. 2. Incase a value for some parameter is changed in future, we can change it at a single point instead of making changes everywhere in every job wherever it is ...

Lubna Khan

• Jan 27th, 2014

By Using Parameters we can avoid hardcoding and assign values at runtime

Answer Question  Select Best Answer

How can we load three different flat files(1 file .txt,2 file .csv,3 file xml) to sequential file at a time?

Narra

• Jul 21st, 2015

Ready all the 3 source as a fixed width file. Otherwise it wont possiible untill unless having the same format

Devesh Ojha

• Aug 11th, 2014

If Metadata is the same then we can load by doing the Union operation and if metadata is diffrent then first sync the metadata and then load them .

Answer Question  Select Best Answer

How we read comma delimiter file in sequential file stage and how we can remove the header and footer from a comma delimiter file?

deepakatsit

 Profile Answers by deepakatsit Questions by deepakatsit

• Oct 29th, 2014

For Removing Header file you can use SED Command of UNIX to remove Header.

deepakatsit

 Profile Answers by deepakatsit Questions by deepakatsit

• Oct 23rd, 2014

For Sequential file there is an option "First Row Column Name" set to true so Header is removed and File End Type You need to select through which Footer is Removed.
Now For Comma Delimiter Use : :"Field Defaults -> Delimiter = Comma"

Answer Question  Select Best Answer

Say I have 5 rows in a source table ‎and for each rows 10 rows matching in a lookup table and my range is for lookup is 9 to 99. what will be the row count in output table?

barak

• Nov 21st, 2014

That depends on , if you set up "more than one row match" you will get you "Cartesian Product"

ramireddy

• Oct 17th, 2014

You will get same no of records in the source even there are duplicates in look up data

Answer Question  Select Best Answer

what is slowly changing dimension(SCD)? How do we rectify it in datastage.

sabz R

 Profile Answers by sabz R Questions by sabz R

• Nov 7th, 2014

We can use surrogate key generator to rectify this problem in datastage..

sabz

• Nov 5th, 2014

SCD is a common problem particular to database.This applies to cases where the attributes for a record varies over time.This can be solved by 3 types.type1,type2,type3

Answer Question  Select Best Answer

Explain some scenarios where a sequential file stage runs in parallel?

Chandra

• Jan 22nd, 2015

If you have multiple files ,need to change Read method to FILE PATTERN ,Then its run parallel mode

Balu

• Nov 25th, 2014

Changing the "no.of readers per node" to more than one . you can read a sequential file in parallel mode

Answer Question  Select Best Answer

i have one source file which contains the below data
input column: DOB varchar(8)
20000303
20000409
1999043
1999047
validate the Date if valid date else pass the default-1999-12-31,convert varchar to date

Sam

• Dec 17th, 2014

Hi, Check for valid date as below: 1.> Len of the string =8 then Date < sysdate else default date 2.> We use a) "Iconv" function - Internal Convertion. b) "Oconv" function - Exter...

sonali

• Dec 6th, 2014

In transformer stage use stringtodate(datecol,format)

Answer Question  Select Best Answer

11. Find The Output With out PIVOTE stage
Source File: Target
SNO, MATHS, PHYSICS, CHEMISTRY SNO, MARKS
101, 70, 80, 90 101, 70
102, 65, 55, 75 101, 80
101, 90
102, 65
102, 55
102, 75

sreeni

• Jun 22nd, 2016

Buy using Pivot You can archive.
seq--->Pivot(Hor)--->seq
In pivot properties write a derivation MATHS, PHYSICS, CHEMISTRY

DEEPAK KUMAR

• Jul 7th, 2015

Use @iteration function in transformer

Answer Question  Select Best Answer

Can any one help....
I have single column in Source like.....
a
b
c
d
want target as.....
a,b,c,d
thanks in advance

D Hema

• Apr 23rd, 2015

Use the stag variable in the transformer
StageVar=StageVar:,: input column name
go to the constraints :-Lastrow()
map that stage variable to the output column

jallu

• Apr 11th, 2015

By using pivot stage in datastage

Answer Question  Select Best Answer