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

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

If those two stages are sources and if it is valid that though the names of columns from two sources differ but they are same, then use a copy stage infront of one source stage and rename column as pe...

muralidhar

• May 30th, 2013

This is little tricky question.we can do in two ways.

1)we can connect using lookup stage if both columns having same datatype.

2)We can add one extra column that is common for two files then we can connect.

Answer Question  Select Best Answer

If you have a huge volume of data to be referenced, which stage will you use? Join or Lookup stage? Why

Gopi N

• Jul 11th, 2012

If we have a Huge data at reference defiantly we should go to Join stage because Look up takes much time to process hence we will use entire partition but in Join stage we will give the sorted data and it will simplify better than Look-up

arjunreddy

• Aug 24th, 2011

Look up stage

Answer Question  Select Best Answer

How to remove leading zeros in data and transform data to target?

Sunitha

• Dec 2nd, 2013

The main differences between 8.1 and 8.5 are 8.5 has Input looping ,Output looping. 8.5 has saving ,editing and compling is 40% faster. 8.5 has functions like LastRow,LastInGroup and Iteration system...

Rupesh Agrawal

• Nov 8th, 2013

Convert data to integer and convert back to string.

Answer Question  Select Best Answer

i have a sequence of job in DataStage which is taking more than 4 hrs which is supposed to complete in less than 1 hr
so what could be the possibilities to take much longer time than expected?

RamyaSujith

• Oct 6th, 2014

Check if any stage is reading/processing data sequentially which could have been done in parallel.

Raveena Mittal

• Sep 11th, 2014

When sometimes ,some DML statements are executed in the db and they are not committed,then also it may keep the job running for long hours

Answer Question  Select Best Answer

I have a source file having data like:
10
10
10
20
20
20
30
30
40
40
50
60
70
i want three output from the above input file, these output would be:
1) having only unique records no duplicates should be there. Like:
10
20
30
40
50
60
70
2) having only duplicate records,...

Ruchi Gautami

• Dec 30th, 2019

File -->> Sort -->> Transformer -->> O/P File
Sort:
Define the key field and in Property set Key Change column as TRUE.
Transformer:
In Constraints put the below condition:
KeyChange=1 for Unique record O/P
KeyChange=0 for Duplicate O/P.

shaheed

• Nov 20th, 2019

Src->Sggr->Trans->Target(3)
1) Unique- send as it is with link sort
2) Duplicate only- Loop through Count of each row count (constraint Count . 1)
3)Unique Only- Constraints Count = 1

Answer Question  Select Best Answer

input is
cola
1
2
3
this should be populated at the output as

cola
1
2 2
3 3 3

satish

• Apr 2nd, 2015

In Transformer use stage variable Str(%Input_column%,%Input_column%)

sai3689

 Profile Answers by sai3689 Questions by sai3689

• Mar 17th, 2015

@iteration

Answer Question  Select Best Answer

can anyone pls solve in datastage.........
source column is..
A
A
B
B
B
C
C
D
........want output columns(2 cols) as.........
A 1
A 2
B 1
B 2
B 3
C 1
C 2
D 1

THANX IN ADVANCE.

Amulya Kumar Panda

• Jul 11th, 2016

Job flow sequential_file-> eggregate->sort->tranformer-> sequential

fast aggregate stage use count rows and add extra column seq_no
next stage sort -key source column sort order ascending.
tranformer stage use loop while ex-@ITERATION

Kumar

• Jul 8th, 2016

Seq file>transformer>Seq file
1.Mode of execution in transformer must be sequential and data must be sorted on col1
2. Transformer logic:
Stv1=Input column
Stv2=if Stv1=Stv3 Then Stv2+1 Else 1
Stv3=Stv1
3.Output of transformer
Col1,Col2
Input column,Stv2

Answer Question  Select Best Answer

I have 2 files having different meta data and 2 files does not have any common key. How can I load the 2 files data into a single file without using Join stage?

mala

• Feb 9th, 2017

Can we use Merge?

Pavan Kumar

• Jul 11th, 2016

If Metadata is same then you can use "Funnel stage". If tables are different then, use column generator to create a common column for both the tables, then using join stage (Full outer join), join the two different tables.

Answer Question  Select Best Answer

1.Without using stage variable how can we delete the duplicates using Transformer?

2.If we will remove duplicates using Transformer then minimum how many stage variable required for this?

bhargav Konduru

• Nov 21st, 2024

1.goto tfm stage
2.goto stage properties > goto partitions tab > select hash >select all the columns which duplicates>select sort > select unique
3. that will solve your problem

Mokshada

• Jul 10th, 2021

The prerequisite for this is data should be partitioned by a key and sorted.
Later, follow the below steps:
S2 = if input.column = S1 then 0 else 1
S1 = input.column
In constraint : S2=1

And, you will get the expected result.

Answer Question  Select Best Answer

input
-------------
name | no
--------------------
Bose 1
Mani 2
Arun 3

Output
-------------
name | no
--------------------
Bose 1
Mani 2
Mani 2
Arun 3
Arun 3
Arun 3



to get the Using transformer stage

help me...

Sandy

• Feb 15th, 2018

Tx => Functins=>string=>str(iput.name ,no)

muni

• Dec 20th, 2017

Using normalize component
in that transform < length(in.no) >
and assign drop to drag input to output

Answer Question  Select Best Answer

Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database. 

Ganesh

• Oct 8th, 2017

Surrogate key and business key are both are same or not,
if different business key act as a primary key but Surrogate key acts as ?

Datastage Etl

 Profile Answers by Datastage Etl Questions by Datastage Etl

• May 13th, 2011

Surrogate Key is used to ?produce the Sequence numbers. So that, based on the Surrogate Key generated, we can ?identify the ?Unique Id in ?any column.?Surrogate Key is mainly implemented ?in the...

Answer Question  Select Best Answer

ajay kumar

• Oct 25th, 2017

Order of execution inside transformer
Derivation, stage variables then constraint

Amit_Mishra

 Profile Answers by Amit_Mishra Questions by Amit_Mishra

• Apr 11th, 2011

Please follow the following details:Stage Variables-> Constraints-> Derivations/Expressions.Link ordering is mainly based to which link you want to process first.Link Ordering is mainly useful f...

Answer Question  Select Best Answer

ss

• Mar 28th, 2013

JJ, you are wrong.

Apt_ Dump_Score
By using this only we can find.

jj

• Nov 26th, 2012

1 conductor process
3 Section leader process
3 player process ( modify and filter are combined)
1 source sequential file
1 target sequential file
Total : 9

Answer Question  Select Best Answer

pundlik

• Sep 5th, 2014

Compared to Informatica the Data Stage is more User friendly

sunrays_arun

 Profile Answers by sunrays_arun Questions by sunrays_arun

• Oct 26th, 2007

SAS DI studio is best when compared to Informatica and Datastage as it generates SAS code at the back end .SAS is highly flexible compared to other BI solution.

Answer Question  Select Best Answer

vydyu4u

 Profile Answers by vydyu4u Questions by vydyu4u

• Oct 29th, 2010

Hi guys... even I got the same problem... I worked on it ... at last I got the solution.. but I guess u don't believe...I got the same error...but once.. I have connect to internet for browsing ... an...

g.koteshwar

 Profile Answers by g.koteshwar Questions by g.koteshwar

• Oct 19th, 2009

Please try by specifying "." in the HostName.Best Regards,Koteshwar

Answer Question  Select Best Answer