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
Which warehouse using in your datawarehouse
Difference between data warehousing and olap?
What are the job parameters?
What are the steps needed to create a simple basic datastage job?
Define orabulk and bcp stages?
What is ds designer?
Can you explain link buffering?
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
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
Can you explain players in datastage?
What is the flow of loading data into fact & dimensional tables?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the areas of application?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is oci?