how can we extract data with out having any common column
Answer Posted / siri
Hi,
If meta data is same u can achieve this in 2 ways.
1) In job properties -> before job subroutine -> cp file1.txt file2.txt
2) Use Funnel
Meta data is not same then you need key.(With out key it is not possible)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Describe link sort?
How a source file is populated?
Explain ibm infosphere information server and highlight its main features?
Where do you see different stages in the designer?
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
why do u need the IOS upgradation in a FC switch
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
What are the different plug-ins stages used in your projects?
What is a folder? Difference types of stages?
how to add a new records into source?
What are the different layers in the information server architecture?
How do you remove duplicate values in datastage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
In Datastage, how you can fix the truncated data error?
Is it possible to query a hash file?