Answer Posted / kondeti srinivas

IF IT IS SOURCE FLAT FILE THEN SQL OVER RIDE WILL NOT WORK

IF IT IS FLAT FILE USE UNION TRANSFORMER AND
CONNECT 3 SAME SOURCE STRUCTURES OF FLAT FILES TO UNION T/F AND CONNECT TO TARGET. IT WILL GIVE THE REQUIRED OUTPUT

What is the session task and command task?

1114

---

How to join three sources using joiner? Explain though mapping flow.

1189

---

How to update a particular record in target with out running whole workflow?

1627

---

Explain the scenario which compels informatica server to reject files?

1207

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1730

---

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

1185

---

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

1199

---

What is meant by lookup transformation? Explain the types of lookup transformation?

1019

---

Why union transformation is an active transformation?

1101

---

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

1042

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

2070

---

how many types of dimensions are available in informatica?

1177

---

Scheduling properties,whats the default (sequential)

2008

---

Separate from a database, an information bazaar, and an information stockroom?

1127

---

Differentiate between joiner and lookup transformation?

1159

---