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
- 19755 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 scd?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is data merging,data cleansing,sampling?
What is a difference between complete, stop and abort?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
What is a dimensional model?
complex mapping ur project u r invlve can u explain and give real time example give me ?
how can one come to know wether the records loak into the target if we use update strategy
How can we handle two sessions in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain the tuning lookup transformation - informatica
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
Teradata 
