Answer / sathish

we can use any number of source becouse we can get the data from any ny\umber of sources

Answer / sbvp

i agree with mr.satish we will use n number source in
single mapping

Answer / amedela chandra sekhar

WE CAN USE ANY NO OF SOURCES IN A MAPPING AT A TIME.THERE IS NO LIMIT.

Answer / akash

When we are using multiple sources and bringing them in a
single data flow, we need joiners.

No. of Joiners = No. of sources - 1

So this will also depend upon how many joiners can we use
in our mapping.

As per my understanding we can use upto 8 joiners in a
mapping so that it remains stable due to cache memory
constraint.

Please let me know if this is correct.

Answer / naveen

yes Chandra Sekhar you are right, we can use any number of source in a mapping, there is limitation.

Answer / jakir

only 1 source .
because informatica not support to data paralleism

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

Why is sorter an active transformation?

0 Answers  

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?

9 Answers  

what is row level and column level indicator?

1 Answers   TCS,

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

1 Answers   HCL,

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,

What is update strategy transform?

0 Answers  

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,