Interested to Buy Any Domain ? << Click Here >> for more details...
how can we extract data with out having any common column
- 7 Answers
- 17390 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 |
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
What is difference between join, merge and lookup stage?
What is use Array size in datastage
How can we run same job in 1 day 2 times
Can we use target hash file as a lookup ?
What is exact difference between Parallel Jobs and server Jobs..
What is the difference between Datastage 7.5 and 7.0?
Highlight the main features of datastage?
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
How can u write exception handling in seq file????
Why do we use exception activity in Datastage?
Teradata 
