Answer Posted / swetha

Yes.By setting the option always runs the session.

lookup transformation with screenshots

4050

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7184

---

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2160

---

What is meant by incremental aggregation?

1185

---

What are active and passive transformations?

1134

---

Explain how many types of dimensions are available in informatica?

1173

---

How to convert multiple rows to single row (multiple columns) in informatica

1429

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1212

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10322

---

what is Active lock explain

2858

---

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?

1960

---

How to handle decimal places while importing a flatfile into informatica?

1242

---

What are the components of the workflow manager?

1184

---

tell me about your project functionality

2383

---

How do you migrate data from one environment to another?

1149

---