Answer Posted / suri

it is not possible to load data form source to target with
out using transformation the reason is while loading the
data from source to targets there will be definitely
modifications in changing the data for example to calculate
the rank of the table like that.... simply the interviewer
will twist us . how we r confident in the subject .....

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1480

---

What are some examples of informatica etl programs?

927

---

What will be the approach?

970

---

What is a filter transformation and why it is an active one?

966

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2200

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3694

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2127

---

What is the benefit of partitioning a session?

1168

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

999

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1058

---

What does cheating measurement mean?

1041

---

What is the session task and command task?

1044

---

How can one identify whether mapping is correct or not without connecting session?

1435

---

Have you worked with/created Parameter file

1655

---

Which version configuration tool used in ur project?

3243

---