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 we integrate different flat file data in a single mapping and with in a single execution

1 Answers  

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

0 Answers  

How can we delete duplicate rows from flat files?

0 Answers  

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

0 Answers   TCS,

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

What is olap (on-line analytical processing?

0 Answers  

how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)

3 Answers   Cognizant, HP, TCS,

Can we insert ,update ,delete in target tables with one update strategy tran.?

2 Answers   Zensar,