Answer Posted / guest

Guess,Connect the output to two instances of same target

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

2157

---

What is the status code in stored procedure transformation?

1180

---

What are Dimensional table?

1053

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1086

---

Write the unconnected lookup syntax?

1079

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1243

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1950

---

Informatica settings are available in which file?

986

---

What the difference is between a database, a data warehouse and a data mart?

1148

---

What are the tasks that can be performed using sq?

1088

---

What is a snowflake schema?

990

---

What do you mean incremental aggregation?

1072

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2068

---

scenario where i can use only concurrent execution of workflow.

3161

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1897

---