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
- 19477 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 |
why u go for dimensions ?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Briefly define a session task?
what is degenerated dimension?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
Can we use parameters of parameter file in presession command
how may sources can be used in a mapping at a time?(limit)
How will you combine 3 different sources with a single source?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
Does an informatica transformation support only aggregate expressions?
How might you approve all mappings in the archive all the while?
Teradata 
