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.

How many repositories can be created in informatica?

1 Answers  

---

what is diff b/t sorter t/r and agg have the option sorter property...

1 Answers  

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

How to handle decimal places while importing a flatfile into informatica?

1 Answers  

---

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

---

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

Why we use stored procedure transformation?

4 Answers  

---

supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

What is the difference between router and filter?

1 Answers  

---

What is the function of aggregator transformation?

1 Answers  

---

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

---