Answer / shashikiran

If it is horizontal join then we should use joiner transformation having common columns in both the flat files if it is more than 3 flat files, then number of joiners will no. of flat files - 1 i.e,
if suppose there are 4 flat files then 3 joiners are used.
If the flat files structure is same then we can go for vertical joining by using Union transformation or by using indirect file loading concept.

HOW CAN U FIND THE SESSION START TIME? chandumba2005@gmai.com

2 Answers   TCS,

---

i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica

5 Answers   Cap Gemini,

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers   IBM,

---

What is the advantage of persistent cache? When it should be used.

1 Answers   Wipro,

---

Explain the mapping variable usage example in informatica

0 Answers   Informatica,

---

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

---

What is meta data and system catalog?

2 Answers  

---

how to get the data from the client machine and how to get server location data to client loction can any body explain to me

1 Answers   TCS,

---

What is informatica worklet?

0 Answers  

---

What is the difference between a table and the materialized view?

2 Answers  

---

How to run a session, which contains mapplet?

1 Answers  

---