Answer Posted / honey

We can remove the duplicate values from the lookup by using
the DISTINCT clause with SQL queries.

Please let me know how to make encryption and decryption with example?

1870

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1043

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1956

---

Explain scd type 3 through mapping.

927

---

What is the use of target designer?

1001

---

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2118

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7300

---

What do you mean by worklet?

1032

---

How to create a non-reusable instance of reusable transformations?

1074

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

1245

---

What is the advantage of informatica?

1025

---

Explain sql transformation in script mode examples in informatica

1074

---

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

1024

---

What are the different types of repositories created using informatica?

1078

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1971

---