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
- 11809 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subhash
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 |
Post New Answer View All Answers
Can you explain tagbatch restructure operator?
How do you import and export data into datastage?
What are the different kinds of views available in a datastage director?
How the ipc stage work?
Why do you need stage variables?
What is the roundrobin collector?
how do u catch bad rows from OCI stage? And what CLI stands for?
Why fact table is in normal form?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
What is merge stage?
What are the repository tables in datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is data partitioning?
What are the different types of lookups in datastage?
What is oci?
