Answer Posted / anu

sq->(seq)->exp->rtr->emp1(condition rowid <=100)
->emp2(condition rowid >100 and rowid<=200)
->emp3(condition rowid >200 and rowid<=300)
in exp t/r add new port and rename it as rowid and connect
to rtr.
note connect next val to rowid(in exp t/r).
in seq t/r change properties like
start value=1
increment by=1
last value=300
currval=1
cycle check it save it.

Explain about Informatica server process that how it works relates to mapping variables?

1128

---

On which transformations you created partitions in your project?

1433

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7498

---

Difference between Target-based loading and constraint-based loading?

1042

---

waht type of interface is used for testing the data in informatica

2297

---

How are indexes created after completing the load process?

1718

---

What are the measure objects?

1255

---

What is fact table? Explain the different kinds of facts.

1125

---

How we can create indexes after completing the load process?

1200

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2403

---

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

1140

---

What is the use of source qualifier?

1184

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7178

---

What do you understand by a term domain?

1173

---

Enlist few areas or real-time situations where informatica is required.

1139

---