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
how many rows sorted in sort stage by default in server jobs
What is active and passive stage?
What are the types of jobs we have in datastage?
Explain usage analysis in datastage?
describe the Steps to confiure a Qlogic switch
explain about citrix scheduling tool in datastage
What could be a data source system?
Where the datastage stored his repository?
Explain datastage architecture?
Can we use target hash file as a lookup ?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
what is the use of skid in reporting?