Answer / abhinaw prakash

When we want to Update the Target without any Primary key
but with matching columns then we ll go for Target update
override.
The Integration service outputs a Default query,we need to
make the changes according to the column we want to Update.

What is decode in informatica?

0 Answers  

---

Major difference between SQL override and Lookup Sql override

1 Answers  

---

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

3 Answers  

---

how do u tune queries?

1 Answers  

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---

What are different types of transformations available in informatica?

0 Answers  

---

What is the use of code page?

0 Answers  

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)

5 Answers   iFlex,

---

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

4 Answers   TCS,

---