Answer / guest

we use lookup transformation to lookup data in a relational
table ,view or synonym.and by using lookup transformation
we can perform the following jobs
-to get the related value
-to perform the calculations
-to update the slowy changing dimentions

What are 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?

0 Answers  

---

can you please explain me pre session and post session options?

3 Answers   BTBP,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

From where we can start or use pmcmd?

3 Answers  

---

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.

1 Answers   DELL,

---

Explain about HLD and LLD ?

16 Answers   Accenture,

---

my source is a comma delimited flatfile as eno, ename, sal 111,sri,ram,kumar,1000 and my target should be eno ename sal 111 sri ram kumar 1000 i.e; we need to eliminate the commas in between the data of a comma delimited file.

5 Answers   IBM,

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  

---

How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,

---

In Lookup transformation a sql override should be done and disable the cache how do you do this procedure?

2 Answers   Wipro,

---

What is Datadriven?

2 Answers   Informatica,

---