-
Generate Surrogate Key in Database
How we will generate Surrogate Key in Database not in Datastage.
-
SCD Insert, Update and Link Data
While implementing SCD, there are two output links updating data to same table. One link for insert and one link for update. How it is possible? Will it not result a write lock on a table if two links accessing same table for writing?
-
-
-
How to seperate two diff datatypes and load it into two files?
i have a source file1 consist of two datatypes
file1:
no(integer)
1
2
3
&
dept(char)
cs
it
ie
and i want to seperate these two datatypes and load it into target files
file2 & file3.
how can i do this in datastage and by using which stage?
-
User Created Stages
Explain Wrapped, Build and Custom stages?
-
Reading multiple files through sequential file
What are the ways to read multiiple files from sequentila file if the both files are differnt
-
Datastage partition
Which partition followed by joiner,merge. lookup,remove duplicate
-
Datastage scenario - two columns in the source
I have two columns in the source , COl A and Col B .
Input is like
Cola Colb
100 ABCDEF
I should achieve the output as
Cola Colb
100 A
100 B
100 C
100 D
100 E
100 F
Note : Colb is not of fixed length .
-
Distribution of Number of rows equally.
Hi all,
I have 100 rows in a table and want to distribute the data by 4 equal parts and write to four sequential file. here the source data keeps changing. Example : if source data is having 1000 rows the target files have to get 250 rows each in the four files.
1000/4 = 250 each
100/4 =25 each -
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? -
Dimension Modelling types along with their significance
Data Modelling is Broadly classified into 2 types. a) E-R Diagrams (Entity - Relatioships). b) Dimensional Modelling.
-
-
Count in Dataset
How to get the dataset record count? with out using orchadmin command
-
Datastage Performance Tuning
How to improve the Performance Tuning any 5 points
-
-
Datastage scenario - Flat file
Source is a flat file and has 200 records . These have to split across 4 outputs equally . 50 records in each .
The total number of records in the source may vary everyday ,according to the count records are to split equally at 4 outputs.
Could someone post an answer for this question.
Thanks -
Single column with multiple rows should be converted into single row with commas
Can any one help....
Source is.....
a
b
c
d
want target as.....
a,b,c,d
thanks in advance -
Convert Column Data into Row Data
Solve in Datastage
Input:
col1, col2, col3
----------------
a, b, c
d, e, f
Output like
Col
---
a
b
c
d
e
f
-
Change Partition to Auto in Join stage
What will happen if we will change the partition to Auto in Join stage?
DataStage Interview Questions
Ans