Interested to Buy Any Domain ? << Click Here >> for more details...
how can we extract data with out having any common column
- 7 Answers
- 17413 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 |
Differentiate between Join, Merge and Lookup stage?
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?
What are the functionalities of link partitioner?
Explain usage analysis in datastage?
i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
what is snow flack schema?
How to create user defined environment varibale(parameter)?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
Why we use parameters instead of hard code in datastage.
Tell me the syntax of Configuration file?
Can you highlight the main features of ibm infosphere information server?
How to convert table data into xml file using xml output stage? please explain step by step;
Teradata 
