Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5 Answers
- 11680 Views
- IBM, I also Faced
- E-Mail Answers
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 define satge variables in transformer stage
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
Can you highlight the main features of ibm infosphere information server?
What can we do with datastage director?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Define Job control?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
Difference between sequential file and data set?
what is data mapping
what are the types of nodes
how can we create rank using datastage?what is the meaning of rank?
What steps should be taken to improve Datastage jobs?
Teradata 
