Answer / cuckoo sreedhar

Lookup on flat file is possible.
Union Transformation is present.
Version Control.
LDAP Authentication.
supporting of 64mb architecture.

Answer / sarath

1)We can use flat file as a target
2)we can use flat file as a lookup
3)Mainly union t/r is introuduced in 7.1
4)Data profiling and versioning
5)Propagate attributes
6)we can do partiotions upto 64

i have source file data empno,ename,sal 100,ram,1000 200,tyu,2000 300,gh,3000 out put as e empno,ename,sal 100,ram,null 200,tyu,1000 300,gh,2000 how to load it?

5 Answers   Cap Gemini,

---

What are the phases in SDLC?

3 Answers  

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

0 Answers   iGate,

---

4 yrs etl devloper roles and responsibilities?any body give solutions

0 Answers   TCS,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

---

What is a test load?

1 Answers  

---

What is aggregate cache in aggregator transformation?

0 Answers   Informatica,

---

Why touse stored procedure in ETL Application?

2 Answers  

---

Explain the types of lookup transformation?

0 Answers  

---

what is the location of parameter file in informatica?

1 Answers   TCS,

---