If we increase the nodes wt will happens?

barak

• Nov 21st, 2014

Increasing node will not always increase speed it might create lock for example in mass update .

Indudhara V

• Oct 8th, 2014

Node is just a process. Its a logical thing used to increase the efficiency of the jobs by running them in parallel just like multi processing in operating system. Each node processes may run on the same processor or different processors.

Answer Question  Select Best Answer

I came across this question many times in interview, In specific what can i answer..... Please help..

rstrainings

• Apr 15th, 2015

we can say like there is a staging area to store the data in the form of tables, and then it transforms to ETL stage (Here we will do all the conversions,remove duplicates,joining,merging etc) then di...

shiv

• Jun 11th, 2014

The above answer, is to architecture of Datastage, its not the architecture of project. Project architecture would be like: ***************************** You have: 1 Source--------> 1 Staging Area----...

Answer Question  Select Best Answer

Can any one help....
Source is.....
a
b
c
d

want target as.....
a,b,c,d

thanks in advance

Rajendra

• Jul 30th, 2024

Without "Pivot stage"
Source --> Transfer --> Target
In Transfermer Stage (Sequential mode)
1) Stage Variable: sv = sv:,:inputcolumn
2) Constraint: LastRow()
3) Derivation: Trim(sv,,,"L")

kalyanreddy

• Jan 30th, 2024

Using with pivot stage, we can convert the rows into columns ; source --> pivot -->target.

Answer Question  Select Best Answer

I have the 10 input file like F1,F2...F10 then I need to load these 10 input files into 10 target Output tables like T1,T2...T10. Here is the scenario for 10 tables But in future If i will receive 100 input files then I need to load it into respective 100 target tables.

After loading the input files into target tables I need a confirmation in the respective target tables(By input File...

Reddy

• Jun 28th, 2017

This can be achieved by creating multiple instance job and parameterizing the source file name, table name and also need to enable run time column propagation.

shasank

• Apr 24th, 2017

We can do that allowing multiple instances for a single job in the job properties tab.

Answer Question  Select Best Answer

I have an input file in the below format :

NAME SAL
---- ---

A 4000
B 3000
C 8000
A 2000
B 7000
C 5000
B 2000
C 9000
A 1000


If I will use Sort ---> Aggregator Group by then it will give 3 columns like NAME,MAX(),MIN()

NAME MAX() MIN()
---- -----...

Sirisha d

 Profile Answers by Sirisha d Questions by Sirisha d

• Apr 18th, 2017

Job Design : Sequential File --> Aggregator --> Transformer --> Sequential File Aggregator : Group by - EmpName Col for Calculation - Salary Generate two columns - one for maximum salary (Max()...

Neha

• Apr 7th, 2017

Use Seq File->Aggregator Stage (group by Salary, Emp_Name and find min, max salary)->use Pivot(horizontal Pivot)

Answer Question  Select Best Answer

pradeep

• Apr 20th, 2012

Actually Data stage director is the GUI based component and this is the Clint component, The main use of Director is view logs, we can see view log and status of running job,By using the multiple instances we can run the job in period of time for testing propose.schedule the job.

abhijeet

• Mar 12th, 2012

DS Administrator is use to see the log of job.Administrator monitor the job.

Answer Question  Select Best Answer

rohitdagar

 Profile Answers by rohitdagar Questions by rohitdagar

• Jan 17th, 2009

Start DataStage Engine Resource Service, DataStage Telnet Service and DSRPC Service in control panel
- Administrative tools - Services or directly run command "services.msc"to open services window..

Hisin

 Profile Answers by Hisin Questions by Hisin

• Jun 26th, 2008

You must give an IP adress by configuring in panel config => Network

Answer Question  Select Best Answer

manoharkolukula

 Profile Answers by manoharkolukula Questions by manoharkolukula

• Jan 25th, 2008

Here in server we have to use some stages like link partitioner, link coll, inter process.. to implement ll'lism. And sometimes we have to use lot of stages to implement specific logic bcoz of&nbs...

sanchit_states

 Profile Answers by sanchit_states Questions by sanchit_states

• Jan 18th, 2008

Server jobs while using look up converts code into .osh languagewhile Parallel converts the code in C++ code ..leading to the req of VC++ compiler.

Answer Question  Select Best Answer

What is the uses of the copy stage with out copies input link to output link datasetsand it can have any purposes pls send me with example

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

Use Copy stage for simple operations like :

to multicast the same input data among multiple output links.
placeholder between stages to avoid buffer issues
renaming Columns
dropping Columns
implicit (default) type Conversions

Akila

• Apr 1st, 2013

Besides used for making copies of the input, copy stage is also helpful for achieving 1) dropping columns between stages 2) to change column names 3) if the scenario is to end the job flow directly f...

Answer Question  Select Best Answer

uma

• Sep 15th, 2017

Kill the process id for the specific job.

jamesbond777

• Mar 9th, 2017

Just to elaborate on kogantis answer. Independent links are stream/input links and dependent links would be the reference links from lookup.

Answer Question  Select Best Answer

Sequencers are job control programs that execute other jobs with preset Job parameters.    

Read Best Answer

Editorial / Best Answer

jagannimmagadda  

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Member Since Jan-2006 | Jan 10th, 2006

---

A sequencer allows you to synchronize the control flow of multiple activities in a job sequence. It can have multiple input triggers as well as multiple output triggers.The sequencer operates in two modes:ALL mode. In this mode all of the inputs to the sequencer must be TRUE for any of the sequencer outputs to fire.ANY mode. In this mode, output triggers can be fired if any of the sequencer inputs are TRUE

Tariq Awan

• Oct 25th, 2016

As previous posts already pointed out, there are only two modes: All or Any. All means all incoming triggers must be true and Any means at least one needs to be true. However, in case, if you want to execute next job even though all the incoming triggers are False, then Seqencer is NOT the solution.

Priyanka

• Mar 10th, 2016

@Rohit: Yes you can run the 2nd job even if the first one fails. For that you need to set the trigger option to unconditional. However, the control comes to the 2nd job only after the 1st job has run (pass or fail).

Improve Answer

sankarganeshvel

 Profile Answers by sankarganeshvel Questions by sankarganeshvel

• May 13th, 2008

Hi ,if your job is using OCI stage as the target stage  .then u can do it. just specify the no of the record in the Transaction handling of the OCI stage . So if the job get aborted after 1000 records  ,say some 1220 then 1000 record will be there in the target table 

nagoosk

 Profile Answers by nagoosk Questions by nagoosk

• Apr 22nd, 2008

It is possible to restart the job after the aborted rows.You have to select the "check point" property in the sequence.There you have to give the aborted final record number.This is only in datastage(PX)

Answer Question  Select Best Answer

RAM

• Aug 27th, 2015

SMP is a shared Disk. Its having 62 or 124 CPUs.
MPP is a shared nothing or clustered systems . We can say combination of multiple SMPs.

Himanshu Maheshwari

• Apr 2nd, 2015

The environment in which you run your parallel jobs is defined by your systems architecture and hardware resources. All parallel processing environments are categorized as one of: SMP (...

Answer Question  Select Best Answer

jaffar95

 Profile Answers by jaffar95 Questions by jaffar95

• Mar 20th, 2008

Yes you can query a hash file using Datastage Administrator --> Command  window -->

John

• Feb 8th, 2007

You can also use a Universe stage if the data is need in your job. I don't recall all details when I used this but I think there is an option when creating the hash file to make it Universe compatable or something like that. Then you can use it in a universe stage and do any query you like on it.

Answer Question  Select Best Answer

How to remove duplicates in datastage?

dwh_com

 Profile Answers by dwh_com Questions by dwh_com

• Jun 22nd, 2008

There are several ways in removing the duplicates depends on the data u have..have to use stage variables effectively to remove the duplicates.use rowprevious compare function.. which is available in datastage...RegardsSriks

Suri123

 Profile Answers by Suri123 Questions by Suri123

• May 9th, 2008

In parallel jobs by using sort stage Or Remove Duplicates stage We can remove duplicate records Regards Suri

Answer Question  Select Best Answer

Anil.K.Thodeti

• Mar 31st, 2017

Cat abc.txt | tr
, | sed s/,$//(Exec command stage), Start Loop (pass this output $CommandOutput), and then send this into a job, and then end loop at the end

karthick

• May 30th, 2014

Parameter file will have comma delimiter.
use cat file1.txt |cut -d, -f1| tr -d "
" command to extract the first field ...
use execute command activity for extracting all the parameter. then finally pass the value to actual job.

Answer Question  Select Best Answer

SRC has 1 record I want 10records in target how is it possible ? plz explain me ?

Ram

• Mar 31st, 2016

Src --> Transform --> Trg

Use Iteration < = 10 for the records...
So you will 10 records in target.

Nikhil

• Dec 15th, 2015

Take a rowgen stage, limit number of rows=9, funnel it src file

Answer Question  Select Best Answer

A Sequences is calling activity 1, activity 2 and activity 3.while running, activity 1 and 2 got finished but 3 got aborted. How can I design a sequence such that the sequence has to run from activity 2 when I restart the sequences?

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• May 8th, 2014

To make the job re-run from activity 3, we need to introduce restartability in the sequence job. For this below points have to be taken care of in Job Sequence Adding Checkpoints: Checkpoints have t...

Ritwik

• Apr 21st, 2014

You have to check the " Do not checkpoint run " checkbox for activity 2. If you set the checkbox for a job that job will be run if any of the job later in the sequence fails and the sequence is restarted.

Answer Question  Select Best Answer

hi

i have sourse like
name,city
johny,newyork
johny,mumbai
johny,del

want output like
name,city1,city2,city3
johny,nework,mumbai,delhi

thanks in advance..

Sharali Sharna

• Nov 24th, 2015

You can use Pivot Enterprise stage to achive this.

Abhinandan

• Nov 20th, 2015

Use 2 stage variable in transformer
Stagevar: if Stagevar1=sno then marks:",":Stagevar Else marks
Stagevar1: sno

map stageVar to marks

Answer Question  Select Best Answer

I have two files target 3 files

file no1:
1
2
3
4

file2
3
4
5
6

output like first file 1,2 first file 3,4 second file 5 ,6 3rd file target how to achieve this

Thwara

• Jul 15th, 2017

First copy the value from your seq. file using "copy stage", then use "funnel stage" to join the two seq. file, then sort them and use "remove duplicate stage" to find the duplicate values (eg: 3,4) t...

Amit

• Jul 28th, 2015

Basically Question is about how you will achive Left Join, Inner Join and Outer Join.

Answer Question  Select Best Answer