how can we extract data with out having any common column
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 add a new records into source?
Can we use Round Robin for aggregator?is there any benefit underlying?
I have a few records just I want to store each records tow times in target how?
I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output
Differentiate between odbc and drs stage?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
how to find out number of records imported into source file?
why we use hash file for lookup?
How you Implemented SCD Type 1 & Type 2 in your project?
Distinguish between informatica & datastage. Which one would you choose and why?
What is the differentiate between data file and descriptor file?
Differentiate between hash file and sequential file?