Answer / bsgsr

An instruction given to the Informatica server the order in
which the sources are to be read and the targets are to be
loaded. It is found in the mappings tab of the mapping
designer tool.target load order is possible only when we
have multiple sources.

Reach me on bsgsr12@gmail.com..............
Kum lets share and be instrumental to one another in
getting a break with the industry.

Answer / prabhu

If u have a multiple source qualifier connected to the
multiple target, then you have specify the order in which
target the informatica server loads the data first.

Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..

5 Answers   iGate,

---

What are the scheduling options to run a sesion?

2 Answers  

---

In seqence generator transformation maximum limit is reached,after reaching maximum limit how will u insert the data

2 Answers   HCL, Schneider,

---

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80

3 Answers   iGate,

---

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

---

what is surrogate id ?

3 Answers   IBM,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

What is factless fact schema?

1 Answers  

---

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---