Answer / kunkala ramakrishna

both the file and table metadata should same then we can join

Answer / surya

You can connect heterogeneous sources to a Union transformation.The transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups

How we can use union transformation?

1 Answers  

---

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

---

How many ways a relational source definition can be updated and what are they?

1 Answers   Informatica,

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

what is mean by complex business rule ?

1 Answers   Cap Gemini,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE

2 Answers   Wipro,

---

what is threshold error in informatica?

1 Answers   TCS, Wipro,

---

What is IQD file?

1 Answers  

---

tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?

3 Answers   IBM, Patni, TCS,

---

version controlling in informatica?

3 Answers  

---