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
- 11423 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 |
What is difference between join, merge and lookup stage?
What is the difference between odbc and drs stage?
how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
j1,j2,j3 jobs r runing iwant to run j1,j3 after j2 how to do this using sequencer? 2)j1,j2,j3 jobs r runing iwant to run j1,j2,j3 how to do this?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is the purpose of pivot stage and types of containers in datastage
Where do the datastage jobs get stored?
Can you define merge?
How a source file is populated?
can explain wt is the pool for file.
Teradata 
