TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING
COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER
TRANSFORMATION ?
- 6 Answers
- 18555 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 the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
What are active transformations? Name them.
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
why union transformation is active transformation?
What are the different threads in DTM process?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
how will u load the data to diminision tables and fact tables,what is the hiraraichy why we are using hirarichy
I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.
Teradata 
