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. ?

0 Answers   CTS,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks

4 Answers   IBM,

---

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

---

Is stop and abort are same in informatica?

0 Answers  

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers   Accenture, VAMA,

---

What is meant by pre and post session shell command?

0 Answers  

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

How can we use mapping variables in informatica?

0 Answers  

---

explain about session partitions ?

1 Answers  

---

How to join three sources using joiner? Explain though mapping flow.

0 Answers  

---