TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 17632 Views
- HP, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mubbasir
This can be done by passing all ports to an expression
transformation and then creating a output port say ID=1 in
both the expression transformation of each file and then
join it using a joiner on ID,hope this helps..
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / pushparao
if there is no matching column two flat files, that means
two tables are different,no need to join the source
definitions in the designer.
there is possibility to join them.
create common columns in both expression transformations.
seqgen
|
sd-->sq-->expr
Joiner-->td
sd-->sq-->expr
|
seqgen
| Is This Answer Correct ? | 10 Yes | 5 No |
Answer / kalyan
How abt using full outer join in the type of join in the
joiner Transformation.
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / prasadreddy
by using the dummy ports u can do..but the both the data
types should be same
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mr.abc
in mapping diagram area, double click on ur sequential file
and rename the port as the other port in another sequential
file.
it wil work out.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / reddy
need not same coloumns , but datatypes are same it can possible
| Is This Answer Correct ? | 0 Yes | 0 No |
what is unit testing?tell me proceedure
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
What is an incremental loading? in which situations we will use incremental loading
How to update records in Target, without using Update Strategy?
To provide support for Mainframes source data,which files r used as a COBOL files
why we use materialized view over view?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain about HLD and LLD ?
how many types transformations supported by sortedinput?
What is best approach to load 100 different source files (Different structure) to differet target tables ?
How to load relational source into file target?
Teradata 
