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

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?

2 Answers   emc2,

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti

1 Answers   Accenture, Patni,

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  

Write the unconnected lookup syntax?

0 Answers  

write a query for how to eliminate the duplicate rows without using distinct?

6 Answers   iGate,

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

Suppose in the next version of Informatica, RTR Xn is excluded. Then how will u route data to different tgts?

2 Answers   Deloitte,

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,