Oracle Connector Stage and Oracle Enterprise Satge
1. What is the difference between Oracle connector stage and Oracle enterprise stage.
2. If we can achieve Oracle enterprise stages task using Oracle connector stage then why Oracle enterprise stage exists?
Delete Duplicates Using Transformer
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?
Load 1 input column values (with delemeter) into different target columns
I have column X which having 3 values A;B;C. How can I load these values into 3 diff cols in the target. If tomorrow I will receive 100 values for same single column I will load into 100 target cols respectively (Same de-limiter) ?
Single Datastage Job Different Output
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?
Datastage Real time scenario
In source table data like this
but I want traget table like this
pls any one one solve this........
Track Source File name in Target File
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?
Dsjob run command in Unix platform
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?
Load a date field value from sequencial file to databse table with out using Transformer
I have an input file in below format
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
Print Minimum & Maximum Salary of Respective Employee
I have an input file in the below format :
If I will use Sort ---> Aggregator Group by then it will give 3 columns like NAME,MAX(),MIN()
NAME MAX() MIN()
Split the Input Columns into Different Target
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?
Merge Two Columns into One Column in Target
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.
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.
How Can we run a Datastage job form sequential mode to parallel mode
Suppose I have designed a Datastage job using sequential file stage,It will run in sequential mode.How can I run it it Parallel mode.
DataStage Interview Questions