Answer / john

if u have 2 or 3 pipelines in your mapping,which pipeline
will load first?
so taget load plan option will give u the availability of
which pipeline will load first and then which one is second
u can decide based on requirement or your logic.
if u doesn't give tagetload planing option,informatica server
will load the pipelines one by one but how it will take we
don't know.

Answer / devi

As Per My Knowledge The Taget Load planing Is Most
Important Event While Loading The Target Generraly One
source Qualifier In Our Mapping then we No need to Think
For This I Mean Seriously, When It Has Multipul Source
Qualifiers Then The Problem Is Arraised, Then We
Designated Which Pipeline Is First,Then Which One Is
Next,If We Did Not Specified Proper Method To Informatica
Server Loads Targets But It Doesn't Tells Us
Proper Order So Always We Specified Order To Load The
Target.

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

How do you remove duplicate records in informatica?

1 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

What is depict expression change?

0 Answers  

---

What is the Difference between PowerPlay transformer and power play reports?

1 Answers  

---

Difference between session variables and workflow variables?

2 Answers   Informatica,

---

I have a scenario with lookup table. in that lookup table have colomns, but i need to process only 10 colomns out of 50. Please te me how can we acheive it?

6 Answers   TCS,

---

what is mapping parameter and mapping variables

1 Answers   BirlaSoft,

---

How are indexes created after completing the load process?

0 Answers  

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

how to load duplicate row in a target

4 Answers  

---