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
What is process model?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Can we use target hash file as a lookup ?
I have a few records just I want to store data in to targets cycling way how?
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
Can you explain link buffering?
How you can fix the truncated data error in datastage?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are stage variables, derivations and constants?
What is the different type of jobs in datastage?
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 'reconsideration error' and how can i respond to this error and how to debug this
What is meta stage?
How can you write parallel routines in datastage PX?
What are the functionalities of link partitioner?