how can we extract data with out having any common column
- 7 Answers
- 14910 Views
- IBM, Switch2iTech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ram
Question not clear. can u check your question.
i think you want to know how to extract data from 2 tables
which doesnt have a common column.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
Answer / sridhar
Use lookup stage .this scenario u will do through lookup
stage .But whatevr You joining columns datatype must be
same.cOrrect me if i am wrong
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / bietl
Hi,
it's just simple as this..
Suppose we have two tables T1 and T2.
Now load the two tables to Seq.files as S1 and S2.
T1............ S1
T2............. S2
Now S1 and S2 are our two seq.files load the two files data
by selecting the S2 seq.file option as append then we will
get the S1 and S2 data as same as T1 and T2.
I hope it will clarify ur question
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / nagakalyan
by using transformer we can but the joining two tables at
least have same datatype and data
| Is This Answer Correct ? | 0 Yes | 4 No |
How to reverse the string using unix?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
Name the different sorting methods in datastage.
What is the precedence of stage variables,derivations, and constraints?
Can you explain link buffering?
What are the partition techniques available in your last project?
how can we create rank using datastage?what is the meaning of rank?
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?
what is hash file
What is lookup table?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
Could anyone give brief explanation bout datastage admin
Teradata 
