Datastage job scenario question
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
Telecom Project Explanation in Data Stage
Explain telecom related project in data stage? For example You are handling data usage and roaming related data. How you will get the data? What mediation team will do? What are the terms such as CDR (Call Detail Record), CDF will you use?
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?
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()
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.
How to automate a Datastage job with out using Sequencer
Without using Sequencer how to design a Datastage job which normally receives input file to run. If tomorrow we will not receive any input file Job should not fail. It will run successfully without any warnings.
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.
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?
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?
DataStage Interview Questions