Answer / emmanuel

Create a dummy port in both the sq transforamtion and join
based on the dummy values

Answer / anithaks

I think we can use Union Transformation in such case!!

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

0 Answers  

---

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

2 Answers   Cap Gemini,

---

can anyone explain me about retail domain project in informatica?

0 Answers   Zensar,

---

SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve

4 Answers   iGate,

---

Design a mapping to get year of join for each employee.

4 Answers   Accenture,

---

WAT IS TEXT LOAD?

3 Answers   Wipro,

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

What are the different lookup cache(s)?

0 Answers  

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

what is target load plan

2 Answers   Cap Gemini,

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

1 Answers   Wipro,

---