Answer / naga

We can write Left outerjoin with the target in Source
Qualifier itself or if ur src is file & target is Table
then using Joine(Left outer) can get the new rows loaded
into target

Answer / itsranjan

Hi, Joiner transformation can do the same job what lookup
does in SCD.

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

---

what is datamart

4 Answers   IBM, Informatica,

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

what is the predefined port in dynamic lookup

2 Answers  

---

case and like function in informtica (my source is XML). case when OS Like'%Windows%' and OS Like '%200%' then 'Windows 200' case when OS Like'%Windows%' and OS Like '%200%'and OS like '%64%' then 'windows 200 64 bit' etc.,,

1 Answers  

---

Explain the etl program with few examples.

0 Answers  

---

Explain what transformation and how many are there in informatica?

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,

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---