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 10 Input files into 10 Target tables at a time
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...
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()
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?
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........
DataStage Interview Questions