There are two file are there .1st file contains 5 records and
2nd file contain 10 records in target they want 50 records.how
can achieve this
Answers were Sorted based on User's Feedback
to the both file we need to add one DUMMY column(value is
like '1', we can use Column generator for this DUMMy column
generation)
then we can JOIN these 2 files based on this DUMMY column.
so, each column of File1 will join with each column of File2
i.e. 5*10= 50 records will come into output.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / datastageboss
The question seems to be incomplte , I am preassuming
that there will be duplicate records in both set of data
on a key say K1
use a join stage , the join type will be full outer join
and key will be K1 ( mentioned above)
At the output link we will receive 5*10 =50 records
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / varaprasad rayi
Hi Bharath ,
this is question under datastage also if u have any idea please send me
mailid:rayprasad05@gmail.com
Is This Answer Correct ? | 0 Yes | 0 No |
use copy stage and funnel stage to make duplicate records.
SEQ>>COPY>>FUNNEL>>TARGET
the solution for this stupid question asked by interviewer:
SEQ>>COPY>>>4links>>>FUNNEL STAGE>>>SEQ.
in seq stage: sed -n '1,50p'
Is This Answer Correct ? | 0 Yes | 2 No |
how to create document in datastage?
What is the purpose of pivot stage and types of containers in datastage
Is the value of staging variable stored temporarily or permanently?
How do u set a default value to a column if the column value is NULL?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???
How many areas for files does datastage have?
how do u capture duplicates through sort & transformer
Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
what is the differeces between hash and modulus partition methods
how can we do null handling in sequential files
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.