Answer / deepak aggarwal

No there is no option in informatica for automatic update
of source/target/lookup/stored procedure definition from
DB/file.
Though you can compare source/target/../.. definitions from
existing DB objects and make out if informatica definitions
needs a updation.

Answer / janardhan avula

No..it could not reflect in informatica.informatica is one
of the Dynamic ETL tool using this tool we can design the
the data effectively according to business
requirement..database is different..

I though am i correct.
if u want more info mail me at avula.janardhan@gmail.com

how can we calculate fact table size?

1 Answers  

---

ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?

3 Answers   HP,

---

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

2 Answers   PayPal,

---

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

4 Answers   Accenture,

---

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

---

Can any one describe what is audit table briefly?how does it look like and what are the columns in it?

3 Answers   Syntel,

---

Differentiate between reusable transformation and mapplet.

0 Answers  

---

why we need informatica

2 Answers   HCL,

---

Examples of Fatal & Non-Fatal error?

2 Answers   Cap Gemini,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

What is the role of informatica in project ?Like i showed financial projects?

1 Answers   Amdocs,

---

explain about session partitions ?

1 Answers  

---