Answer Posted / vemuri vijay

steps
go to mappings
go to wizards
there is two optins
1.getting started
2.scd
go to scd
again three types
type1
type2
type3
select ur requirement
ex.
take type1
select source table and give name for target table
then
next
give target table fields
then
finish
automatically u will get mapping
go to
workflow manager
create
task and
worklet
start task
thats all

Explain in detail scd type 2 through mapping.

609

---

What are the different types of repositories created using informatica?

651

---

What is Session and Batches?

658

---

What are the different versions of informatica?

670

---

How to update source definition?

623

---

---

What are the data movement modes in informatica?

693

---

What is update strategy transform?

563

---

Can u generate reports in Informatica?

651

---

What is dimensional table? Explain the different dimensions.

645

---

Design time, run time. If you don't create parameter what will happen

1417

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1841

---

What does reusable transformation mean?

667

---

What are the different types of transformation available in informatica.

627

---

What are the uses of etl tools?

641

---

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

3438

---