generate date / time dimension in informatica

0 Answers   Informatica,

---

Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..

1 Answers  

---

What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,

---

wat s mapping parameter and mapping variable? how do you set that in a mapping?

3 Answers  

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

What is the use of an aggregator cache file?

0 Answers  

---

Explain about Recovering sessions?

1 Answers  

---

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

---

How to identify this row for insert and this row for update in dynamic lookup cache

3 Answers   CSC,

---

what are surrogate keys?

5 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---