Answer Posted / remesh

BY USING INCREMENTAL LOADING CONCEPT

GO TO SESSION PROPERTIES--->

IN THAT U FIND OPTIONS INITIAL VALUUE AND INCREMENT VALUE
IN THAT U CAN INITIALIZE THE VALUES

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1606

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1988

---

Can you generate sequence numbers without using the sequence generator transformation?

1054

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

918

---

what is SDLC way of code development?

1971

---

What is dimensional table? Explain the different dimensions.

1113

---

whats the logic to load the lower level of granularity of data to fact table.

2208

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1795

---

What is the use of code page?

1013

---

Describe an informatica powercenter?

1038

---

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

1030

---

Plz can any one say me how to get the informatica certification materials and dumps

2001

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4039

---

How can we create index after completion of load process?

1073

---

What is incremental aggregation?

1016

---