Answer / sudhar

Connect the source Qualifier of two different flat files to
two different Exp Trans. Create a dummy output port in both
the exp trans. then using that port connect the joiner
Tansformation

Answer / jana

yes you can join two flatfiles using the joiner t/r even if
you don't have any matching port for that you need to take
one dummy column in source files and based on the dummy
column you can join them

Answer / alisha

Hi Sudhar

What condition we need to give in Joiner transformation to
join tht dummy column.

Answer / vin

create dummy1 port in flat file1
create dummy2 port in flat file2

assign the value '1' to both dummy1 and dummy2.

In the lookup condition use dummy1=dummy2. This is going to be always true so all the records are took into consideration.

Answer / vaas

Hi Jana,

How can we take a dummy column i.e what r the values would
be in that port? We need to take dummy columns on both files?

could u explain clearly. mi id is vaas31@yahoo.in

How can repository reports be accessed without sql or other transformations?

0 Answers  

Why filter transformation is an active one?

0 Answers  

What are the components of workflow manager?

0 Answers  

what is the command to get the list of files in a directory in unix?

5 Answers   iGate,

What is a transaction control transformation?

0 Answers   Informatica,

what is the size of ur database(like oracle)

2 Answers   HP,

What are the connected or unconnected transforamations?

2 Answers  

What is the default join that source qualifier provides?

3 Answers   Informatica,

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

0 Answers   Informatica,

How do you load only null records into target?

0 Answers  

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  

What is complex mapping?

0 Answers