How will you separate the records with special characters in a column. For example
If suppose the column contains
Name*
&Name
Na*me
$Name
Na$me

I need to separate these records alone.

Shrushti

• Jul 16th, 2016

Source - transformer - target.
In transformer,
Namesp --- If alphanum(Name) then 1 else 0
Constraint --- Namesp=0

Answer Question  Select Best Answer

Why we are using orchadmin to remove dataset. why we are not using rm commond in remove dataset..and why you need dataset remove waht is the reason?

Reddy

• Dec 19th, 2016

Dataset is not like a normal file & it is not a single file...based on number og node in config file, those many data files and one descriptor file..are created for each dataset. Hence removing using rm command will corrupt the dataset and will not be removed properly.

Answer Question  Select Best Answer

I have 10 files, in 5 files having same data(3 columns), 5 columns having same data(4 columns). How can I perform funnel and what are stages required from me?

Srinivas

• Oct 7th, 2016

Use column generator to add columns to make the column count is same and also the column names should be same in each files. Then you can perform funnel.

Answer Question  Select Best Answer

I have a source file having 4 columns. How can I store first 2 columns values into one target and the next 2 columns values into another target? Can anyone suggest me here how can I achieve this using Copy stage and without using Copy Stage?

Ram

• Aug 4th, 2016

Hi

you can try with 1) copy stage & 2) transformer stage

Thanks!

Answer Question  Select Best Answer

Can we change the configuration file during run time? If then how?

hema

• Aug 3rd, 2016

First we need to add the environment variable(apt_config_file) to the job parameters

Answer Question  Select Best Answer

I have to design a job, if I run the job it should get 10 records from emp, if another person runs he should get all the records form emp. How to design such a job?

Shaktimaan

• May 2nd, 2018

If you are using Sequential file stage, there we have an option "Read the first row", make it parametrized.
and pass the value to the job using dsjob command as the parameter. also, you may like to use Invocation ID as you need to run the job with the different instances.

Answer Question  Select Best Answer

What is the minimum number of input and output required for Lookup ?

vibgyss

• Aug 24th, 2016

Min of 2 inputs is required by lookup stage and 1 output link is mandatory for any type of lookup i.e. we have 4 types of lookups from 8.0 version those Normal lookup, sparse lookup (only supports 2 inputs one is primary and second is reference), range lookup, caseless lookup

Answer Question  Select Best Answer

How to handle rejects in Transformer & How many rejects a xfm support?

vibgyss

• Aug 24th, 2016

Transformer
The transformer only rejects the data of a column which has nulls and that column is used in the expression then that type data is rejected by transformer stage

No other data is rejected by Transformer Stage
Only one reject link supported by transformer

Answer Question  Select Best Answer

How to find out second highest salary as group wise by using datastage? Can you explain scenarios like pre row salary, next row salary, rank and dense rank

Ranga

• Sep 6th, 2019

Pre and next row salary can be get using analytical functions lag() and lead() functions in SQL

Answer Question  Select Best Answer

I have Customer file & Dealer file.

Dealer file have dealer list who all are present on that day. Count of records may vary based on available dealers.
Customer file have customer list. Count on customer records also may vary daily.

The scenario is Dealer has to call customers in daily bases. We should provide customers record to them. So that they can call the customers....

Chaitra

• Aug 16th, 2017

Use count of customer id - cnt_cst and dealer id - Cnt_dlr in aggregator stage
In transformer,
define a stage variable (sv1) as cnt_cst/cnt_dlr.
@iteration

Answer Question  Select Best Answer

how i can achieve below logic in datastage
A B C D
B C D
C D
D

it can be number and symbol also
1/2
/2
2

SaravanaKumar

• Jul 27th, 2019

Let assume the input file has one column and the value is "ABCD"
Seq file --> Transformer --> Seq File

In Transformer Create Two stage variable
Len(Inut_Field) -> stageVar
StageVar + 1 -> StageVar1

Under looping give the iteration as @ITERATION

Answer Question  Select Best Answer

In a Column 123abc456xyz convert into two files like 123456 fil1 and abcxyz file2

Sandeep

• Apr 8th, 2018

By using convert fun we can achieve it:

in Tx->functions->string-> select convert

Convert (0123456789,,inputLink) ==

Target1 :abcxyz

Convert (abced....xyz, ,InputLink)==
Target2 : 123456

Answer Question  Select Best Answer

I have a sequential file it is having some records and the same file is having header and footer now my question is how to count the records in a file which is not counts the header and footer records and then transform the records in to target and then again we fetch the header and footer to that file which records are matched with the header

Sasidhar Punna

• Oct 24th, 2018

Cat | sed 1d ; $d | wc -l

sed 1d --- for removing 1st row
sed $d ---- for removing last row

Answer Question  Select Best Answer

I have 10 Million records in source and target 5 million records were populated then job was aborted again i go and compile and run the job when that time job will run from 5million 1 record to remain records how?

Hari

• Mar 9th, 2019

Use Upsert function in database connector stage. Or use lookup stage to perform lookup on the source and reference as your target data and load into your target stage

Answer Question  Select Best Answer

Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. 

jagannimmagadda

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Jan 10th, 2006

Container is a collection of stages used for the purpose of Reusability. There are 2 types of Containers. a) Local Container: Job Specific b) Shared Container: Used in any job within a project. ? Ther...

Answer Question  Select Best Answer

Link Partitioner : It actually splits data into various partitions or data flows using various partition methods . Link Collector : It collects the data coming from partitions, merges it into a single data flow and loads to target. 

jagannimmagadda

 Profile Answers by jagannimmagadda Questions by jagannimmagadda

• Jan 10th, 2006

server jobs mainly execute the jobs in sequential fashion,the ipc stage as well as link partioner and link collector will simulate the parllel mode of execution over the sever jobs having single cpu L...

Answer Question  Select Best Answer

narsimhulu.D

• Sep 11th, 2005

Using Orabulk

Answer Question  Select Best Answer

Give the OS of the Server and the OS of the Client of your recent most project

rcp

• Oct 13th, 2005

Server is unix and client machine i.e is ur machine where u design a job is windows xp professional

Answer Question  Select Best Answer

Used for Look-ups. It is like a reference table. It is also used in-place of ODBC, OCI tables for better performance.   

RamaPrasad Batchu

• Mar 8th, 2006

We can also use the Hash File stage to avoid / remove dupilcate rowsby specifying the hash key on a particular fileld

Answer Question  Select Best Answer

CNU

• Aug 2nd, 2005

You use the Designer to build jobs by creating a visual design that models the flow and transformation of data from the data source through to the target warehouse. The Designer graphical interface lets you select stage icons, drop them onto the Designer work area, and add links. 

Answer Question  Select Best Answer