In join stage how we will store the rejected record in one file?

Aloka

 Profile Answers by Aloka Questions by Aloka

• Jul 1st, 2016

Thanks Ram !

Ram

• Jun 30th, 2016

Hi Aloka,
Join stage doesnt support reject link. so just connect join stage --> Transformer stage and provide constraints on Transformer to get rejects in Join stage.

Answer Question  Select Best Answer

In Data warehouse which table will load first and why? Fact or Dimension?

Sri

• Jul 20th, 2016

Dimension table will load first and then fact tables.

Ram

• Jun 30th, 2016

Hi Aloka,
Fact table is connect with different dimension tables with foreign key relationship. Fact table having only Ids & Measures. Dimension tables having detailed descriptions of the Ids.

Thank you !

Answer Question  Select Best Answer

How we will generate Surrogate Key in Database not in Datastage.

Aloka

 Profile Answers by Aloka Questions by Aloka

• Jul 1st, 2016

Thanks Ram !

Ram

• Jun 30th, 2016

Hi Aloka,
we can generate surrogate key on database creating sequence object.
syntax: sql > create sequence < seq_object name >

Answer Question  Select Best Answer

I have an input file in below format
Name DOB
------ ------
A 10-05-1990
B 07-12-2000

Q1 -> How we will load the above file data into a target data base table in a simplest method without using Transformer ?

Q2 -> How will load the Date column into 3 splitted columns(DD|MM|YYYY). Like below
Name DOB
------ -------

amulya panda

• Aug 3rd, 2016

Use in transformer stage and use Ereplace(SOURCE_COLUMN_NAME,"-","|")

Gagandeep Singh

• Jul 29th, 2016

Define delimiter as - in Sequential file stage

Answer Question  Select Best Answer

In your project Which Case you will go for star schema designing and which Case you will go for snow flake schema designing?

Purba

• Jul 4th, 2016

Snowflake schema is used for dimension Analysis. Eg: How many online accounts does an advertiser have.

Star schema is used for metric analysis. Eg: What is the revenue of a customer.

Ram

• Jun 30th, 2016

Star schema --> Fact table is connect with different Dimension tables.
Snowflake schema --> Fact table is connect with different dimension tables. And dimension table/tables refer to another dimensional table.

Thanks !

Answer Question  Select Best Answer

I have 5 source files. In target I need to write it into a single file. But in the output file I need the corresponding input file name i.e which records are coming from which source file. How to achieve this?

sreeni

• Aug 8th, 2016

Hi Aloka we can use seq file properties -> Options -> File Name Column = FileNameCol
you will get source file name to each column. You can identify easily...

Ram

• Aug 4th, 2016

Hi
Use file name column option in seq file stage & do funnel then you will get required output.

Thanks !

Answer Question  Select Best Answer

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

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