Answer / hari

when u set this property value to 3
when u start the session immidiatly i will try to create 3
lookups and try to buils on those lookup's

Where is metadata stored?

1 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

explan ur project architecture?

1 Answers   TCS,

---

How you count the number of records available at your source?

3 Answers   Zensar,

---

how many ways can we implement SCD2?

4 Answers   IBM, TCS,

---

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers  

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

how do u use sequence created in oracle in informatica? Explain with an simple example

6 Answers   CTS,

---