Answer / mohanreddybank

There are different caches we have in informatica
Static, dynamic,persistent,shared lookup cache

Answer / nikitha

dynamic cache

How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,

---

Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??

1 Answers   IBM,

---

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

---

What are some examples of informatica etl programs?

0 Answers  

---

If I am having 6 flat files in data. How can you load the data at a time

2 Answers   CSC,

---

in which situations do u go for starflake schema ?

6 Answers   TCS,

---

Explain about Informatica server process that how it works relates to mapping variables?

0 Answers   Informatica,

---

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

---

Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .

5 Answers  

---

when we dont use aggregator in mapping ?

2 Answers   CSC,

---

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

2 Answers   BirlaSoft,

---

Can we run session without using workflows?

5 Answers   TCS,

---