Answer Posted / suresh

we can load data without primary key but if whenever u need to update the table from informatica then u have to use update override then only u can update the table.

target plan: if u have maultiple source and multiple targets in one mapping then u have to go target load order this option available in mapping tab

correct me if i wrong

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

1368

---

What do you mean by blocking transformation?

970

---

How do you load only null records into target?

1141

---

What are the types of data warehouses?

1425

---

lookup transformation with screenshots

3939

---

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1974

---

Mention some types of transformation?

991

---

What is lookup transformation?

1002

---

How do you migrate data from one environment to another?

1042

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2064

---

What is a shortcut and copy in Informatica and how two are different with each other?

1130

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2350

---

Can we get 1st record through Informatica(without sequence number).

1406

---

Explain in detail scd type 2 through mapping.

986

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1995

---