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()
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.
Generate the Occurrence Number in Output File
How to generate the occurrence no in out put file for the respective no of records in input file
I need a count in the target file how many times the same record is available in input file.
ID NAME LOC
20 B Y
10 A X
20 B Y
30 C Z
10 A X
10 A X
20 B Y
20 B ...
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...
Implement Bulk Collect methodology in Datastage
We are using Bulk Collect methodology in Database to load the bunch of records at a time.How we will implement the same operation in Datastage. If my source having millions of records, I want to load the bunch of records in to target at a time. How?
Separate the Records with Special Characters
How will you separate the records with special characters in a column. For example
If suppose the column contains
I need to separate these records alone.
How to remove reverse duplicates in datastage ?
Objective: The interface aims to consolidate the round-trip ticket cost of passengers.
Description: The source file is a .txt file, train_route_src.txt, consolidated with trains from a particular source to destination. There are many repetitions in the source file (Reverse Duplication: eg. BLR --> BBS and BBS --> BLR). Remove the reverse duplicates and maintain the target in...
How to load 2 files data into a single file without using join stage
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?
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.
Sequential file with Duplicate Records
A sequential file has 8 records with one column, below are the values in the column separated by space,1 1 2 2 3 4 5 6In a parallel job after reading the sequential file 2 more sequential files should be created, one with duplicate records and the other without duplicates.File 1 records separated by space: 1 1 2 2File 2 records separated by space: 3 4 5 6How will you do it
DataStage Interview Questions