Interested to Buy Any Domain ? << Click Here >> for more details...
TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 19744 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 |
write a query following table bookid language 1234 english 1234 french 1234 spanish 1235 english i want the output are bookid lang1 lang2 lang3 1234 english french spanish 1235 english null null
 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?
what is lookup chache?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how
How could we generate the sequence of key values without using sequence generator transformation in the target ??
12 Answers TCS, Tech Mahindra,
How to load the data from a flat file into the target where the source flat file name changes daily?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
what is datamart
What do you mean by blocking transformation?
What is the fact table?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the Difference between sorter and aggregator?
Teradata 
