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
- 10017 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
how to delete one row in target dataset
how to sort two columns in single job in datastage.
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
how to run a sequential file stage in parallel if the stage is used on the TARGET side
What is a datastage job?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
Why we use surrogate key?
Differentiate between validated and Compiled in the Datastage?
How to perform incremental load in datastage?
What is usage analysis in datastage?
What is the precedence of stage variables,derivations, and constraints?
How the ipc stage work?
Explain entity, attribute and relationship in datastage?
Why do we use exception activity in Datastage?
What are the different plug-ins stages used in your projects?
