Answer Posted / krishna

in starschema the fact is denormalised ...all dimension
tables are normalise..there will be primary foreignkey
relation ship between fact and dimension tables.
for better perfomance we use starschema when compare to
snow flake schema ..where fact table and dimension tables
are normalised...for every dimension table tthere will be a
look table ..we have to dig from top to bottom in the
snowflake schema.

What is native users?

1174

---

Tell me about MD5 functions in informatica

930

---

what is SDLC way of code development?

2046

---

How to do unit testing in informatica? How to load data in informatica ?

1130

---

Informatica settings are available in which file?

995

---

Have you worked with/created Parameter file

1668

---

How to join three sources using joiner? Explain though mapping flow.

1152

---

How to extract the informatica rejected data?

1225

---

Which transformation is needed while using the Cobol sources as source definitions?

1178

---

Explain how to import oracle sequence into informatica?

1021

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4167

---

During the running session, output files are created by informatica server. Enlist few of them.

985

---

What is the need for an etl tool?

1070

---

How an expression transformation differs from aggregator transformation?

1046

---

In informatica workflow manager, how many repositories can be created?

1367

---