Answer Posted / ch naveen kumar

let the attribute name be abcabc and name be aaa and table
name be 1

insert into 2 abcabc from 1 where count(aaa)<5;

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2158

---

Difference between Data and Index Caches?

1135

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

1168

---

What is mapplet in informatica?

1053

---

What are the different ways to implement parallel processing in informatica?

1423

---

What is workflow monitor?

1057

---

What is session task and command task?

1288

---

Mention some types of transformation?

1041

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1028

---

What is the cumulative sum and moving sum?

1181

---

What is the surrogate key?

1252

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2073

---

How can you increase the performance in joiner transformation?

1183

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1127

---