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

Differentiate between reusable transformation and mapplet.

1100

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015

---

What is aggregator transformation in informatica?

953

---

What are the different lookup cache(s)?

1118

---

What is the advantage of informatica?

1069

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1205

---

Where do we use mapping variables in informatica?

1071

---

In warehouses how many schemas are there?

1073

---

what is the size of u r source(like file or table)?

2272

---

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.

2201

---

What all join we can perform in LOOKUP transformation?

981

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1273

---

What do you mean by blocking transformation?

1044

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1149

---

Explain in detail about scd type 1 through mapping.

1555

---