By seeing a Datastage job how you will identify which one is Normal lookup and which one is Sparse Lookup?

Ram

• May 23rd, 2017

Sparse look up can be used only for DB stages as Source and Target where as Normal can be used for both files as well as DB stages

Sri

• Mar 30th, 2017

It can be viewed when you open the Oracle connector stage and where the lookup type is mentioned.
By default lookup type is normal

Answer Question  Select Best Answer

Source have single column data, How can I get Target like row 1 goes to target 1, row 2 goes to target 2.

src :-
column_id
1
2
3
4
.
.
.
1000 ,
Target :-
Target1(1)
Target2(2)
Target3(3),
Target4(4)
.
.
Target1000(1000)

How can you achieve this scenario?

Yash Ojha

• May 9th, 2020

We can use the option "generate multiple files" in sequential file stage and then assign the data column as Key. SO with every change in key it will generate a new target file.

Rv

• Dec 7th, 2019

There are thousand rows, who will write thousand different where conditions and then will configure 1000 different files, is there any other solution which dynamic?

Answer Question  Select Best Answer

tisha24

 Profile Answers by tisha24 Questions by tisha24

• Dec 29th, 2008

In server jobs we can make use of HASH FILE stage to eliminate the duplicate rows.In parallel jobs we can use REMOVE DUPLICATE  stage to eliminate the duplicates.we can also use sort stage to eli...

madhava1238

 Profile Answers by madhava1238 Questions by madhava1238

• May 5th, 2008

Sql: delete from tablename a where rowid>(select min(rowid) from tablename b) where a'key values=b.key values.datastage server:using sort stage(option:allow duplicates(yes/no))or hash fileparallel: remove duplicate stageRegards,Madhava

Answer Question  Select Best Answer

saratgunji

 Profile Answers by saratgunji Questions by saratgunji

• Jul 13th, 2011

Both Server jobs and Parallel jobs run on Data Stage server only. where are server jobs performance is slower than parallel jobs because parallel jobs run on SMP and MPP. parallel jobs has partition...

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Nov 29th, 2009

Datastage parallel jobs can run in parallel on multiple nodes.  Server jobs do not run on multiple node.Parallel jobs support partition parallelism(Round robin,Hash,modulus etc.), server jobs don...

Answer Question  Select Best Answer

Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.

BHANU

• Jul 9th, 2013

Dimensional modeling is a technique for conceptualizing and visualizing the data there are two types of dimensional modeling

1.Snowflake schema
2.Star schema

cyberdiptikanta

 Profile Answers by cyberdiptikanta Questions by cyberdiptikanta

• Jun 26th, 2010

Dimensional Modelling:It is a designing methodlogy for designing datawarehouse with dimensions& facts.It is of three types 1) Conceptual Modelling 2) Logical Modelling 3) Physical Modelling1) Conc...

Answer Question  Select Best Answer

Mili Jon

 Profile Answers by Mili Jon Questions by Mili Jon

• Jan 16th, 2011

Job aborts and logs can be seen on Director client. However a notification can be set using the notification Stage to send emails during failure.

gagan8877

 Profile Answers by gagan8877 Questions by gagan8877

• May 8th, 2007

U can define a job sequence to send an email using SMTP activity if the job fails. Or log the failure to a log file using DSlogfatal/DSLogEvent from controlling job or using a After Job Routine. orUse dsJob -log from CLI.

Answer Question  Select Best Answer

Nikvik5

 Profile Answers by Nikvik5 Questions by Nikvik5

• Jun 23rd, 2009

SQL tuning is done by following steps:- Run an Explain plan for SQL statement.- Gather statistics for the tables.- partition the tables when there is huge data.- check for the sort_area_size, buffercache, logbuffer parameters.

vinoth kumar

• Dec 18th, 2006

sql tunning how to per form thisin sql-server... through query analyser is needed and explain brief steps for tunnning

Answer Question  Select Best Answer

tanisha11

 Profile Answers by tanisha11 Questions by tanisha11

• Sep 24th, 2008

You can use Transformer stage in server jobs in place of LookUp Stage in PX and Hashfile for reference data set in place of LookUp File stage which was used in PX.

Purnima

• Mar 30th, 2006

In server canvs we can perform 2 kinds of direct lookupsOne is by using a hashed file and the other is by using Database/ODBC stage as a lookup.

Answer Question  Select Best Answer

ETLSafari

 Profile Answers by ETLSafari Questions by ETLSafari

• Oct 23rd, 2008

Control-M and UC4 are famous tools for datastage

Upul

• Apr 24th, 2007

Contl-M job schedular

Answer Question  Select Best Answer

Ramyapriya Sudhakar

• Jul 9th, 2014

operational data store : It is unlike real EDW ,data is refreshed near real time and used for routine business activity. It is used as an interim logical area for data warehouse. This is the pla...

Dharmendra

• Sep 22nd, 2006

An operational data store (or "ODS") is a database designed to integrate data from multiple sources to facilitate operations, analysis and reporting. Because the data originates from multiple sources,...

Answer Question  Select Best Answer

jaffar95

 Profile Answers by jaffar95 Questions by jaffar95

• Mar 20th, 2008

Hash file can be used to elimate duplicate records

klsrao

 Profile Answers by klsrao Questions by klsrao

• Apr 23rd, 2007

If you dont have remove duplicates stge, you can use hash file to eliminate duplicates.

Answer Question  Select Best Answer

Krishnarao j

• May 30th, 2006

What is type 30,17...

shameerok

• Mar 22nd, 2006

yes you can implement Type1 Type2 or Type 3. Let me try to explain Type 2 with time stamp.Step :1 time stamp we are creating via shared container. it return system time and one key. For satisfying the...

Answer Question  Select Best Answer

bmdirshad

 Profile Answers by bmdirshad Questions by bmdirshad

• May 16th, 2008

No, U cannot run parallel jobs in serverbut u can run parallel jobs AS server jobs, my changing APt_Config file and setting node = 1 or setting node map constrain with node1

server on parllel

• Apr 21st, 2006

By configuring config file

Answer Question  Select Best Answer

Fahmida

• Jul 31st, 2007

1.System Variables are inbuilt functions that can be called in a transformer stage2.Containers is a group of stages and links,thy are of 2 types,local containers and shared containers3.Using IPC,Manag...

Shiva

• Dec 13th, 2006

The following rules apply to the names that you can give DataStage jobs:? Job names can be any length.? They must begin with an alphabetic character.? They can contain alphanumeric characters and underscores.Job category names can be any length and consist of any characters,including spaces

Answer Question  Select Best Answer

joel

• Jun 20th, 2012

The above answer is wrong. Please follow the steps below to load the excel in dataastage :- first open excel sheet and open->saveas-> then save the file as .csv extension while importing u have to s...

srinu5077

 Profile Answers by srinu5077 Questions by srinu5077

• Jan 4th, 2012

I did same as step1, but when i import the metadata it asking username and password, when press ok button it shows NO MATCHES FOUND, pls help me

Thank you
Regards
Srinivas

Answer Question  Select Best Answer

sudhakar.netha

 Profile Answers by sudhakar.netha Questions by sudhakar.netha

• May 29th, 2008

The reason is performance,OCI stage is faster while dealing with bulkdata and where it comes to ODBC stage its slow.But one thing ther is no rule that we Should use only OCI stage while dealing with oracle database.

pumabhanu

• Apr 19th, 2007

While using Oracle?Database as source we use oracle enterprise stage,?because it retrieves bulk of data fastly, where as the odbc stage?has drivers and are slow while retreving bulk of data.

Answer Question  Select Best Answer

shobhitvkgupta

 Profile Answers by shobhitvkgupta Questions by shobhitvkgupta

• Jun 3rd, 2008

DataSet supports parallelism but sequential file doesn't

kirupakaran

• Dec 12th, 2006

hi allsequential file:it act as a source & permanent storage for target.it 's extend is .txt.dataset:it act as a temporary storage stage ,mainly it used before the target stage while using this st...

Answer Question  Select Best Answer

dhora9999

 Profile Answers by dhora9999 Questions by dhora9999

• May 23rd, 2011

 Ya you are right, If you do not know the answer please do not cut paste here. Please answer the questions promptly. do not confuse anybody..Thanks D!! 

rajani

• Feb 21st, 2007

In the Filter option,u can use the UNIX command like this to filter the input records..head -3 input_file.dat

Answer Question  Select Best Answer

Where do you specify nodes for datastage jobs?

srinivas

• Jan 30th, 2012

Node is nothing but an identified by the number of nodes on which parallel jobs can run r not

j.padma89

 Profile Answers by j.padma89 Questions by j.padma89

• Jul 18th, 2011

In app config file which will be named as default.apt

Answer Question  Select Best Answer

the_xxx

 Profile Answers by the_xxx Questions by the_xxx

• Mar 19th, 2007

For every job in DataStage, a phantom is generated for the job as well as for every active stage which contributes to the job. These phantoms writes logs reg the stage/job. If there is any abnormality...

ATTILI

• Mar 19th, 2007

For every job in DataStage, a phantom is generated for the job as well as for every active stage which contributes to the job. These phantoms writes logs reg the stage/job. If there is any abnormality...

Answer Question  Select Best Answer