Identify Header, Detail and Trailer Records
Identify Header, Detail and Trailer records in the incoming file and verifying whether trailer count is equal to total number of detail records.
My input is
Detail row 1
Detail row 2
Detail row 3
Here I want to see whether total number of detail records is equal to total number of trailer record.
If so proceed...
I would like to have output as like this 101 90 next line 102 65 next line 102 55 etc...
11. Find The Output With out PIVOTE stage
Source File: Target
SNO, MATHS, PHYSICS, CHEMISTRY SNO, MARKS
101, 70, 80, 90 101, 70
102, 65, 55, 75 101, 80
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 we can implement Bulk Collect methodology in Datastage
I have faced an interview question recently.
In database we are using Bulk Collect concept to load the bunch of records ata time.
How we will achieve the same process in Datastage ?
Can we use any paticular stage or any other methodology we can implement.
Can any one help me on this.
Thanks in advance.
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?
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?
Display with Commas
Solve these with suitable logics in datastage
Input is like..
want result like
Maximum score details among 10 records using transformer stage
I have 5 records in student table. I want maximum score student details. How to do this with transformer stage.
Example:Input::: Student table
I want output like this::
How to get top five rows in DataStage?
How to get top five rows in DataStage? I tried to use @INROWNUM,@OUTROWNUM system variables in transformer..but they are not giving unique sequential numbers for every row...please help!
Thanks in advance!!
How to achieve this?
My input data:
My output should look like
Customer_ID Customer_Name Customer_City
100 ABC Delhi
Sequence Job Creation Scenario
You are given 2 jobs say job A and Job B with parameters x and y respectively. You need to create a sequence job. If you pass parameter x then Job A should run, If you pass parameter y then Job B should run, if you dont pass any parameter then Both Job A & B should run
Add a Sequence Number for a Table/Row
I have a file structure that I need to add things to and it is as follows:
I need to know how to create a sequence number the tables in between the PROV_TB. The PROV_TB has been assigned a number I created (153365000 is the 1st, 153365001 is the...
What are Stage Variables, Derivations and Constants?
Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column. Derivation - Expression that specifies value to be passed on to the target column. Constant - Conditions that are either true or false that specifies flow of data with a link.
DataStage Interview Questions