Answer Posted / dl

Hi Achoudhr,

here u go,

sq--->agg----->target

In agg dont use group by on any port and take output
columns for both id & date ports, use 'min' function in
outpput expression and connect output ports to desired
target columns.you will get only one output row that is 101
2/4/2008.

note: if u use group by mapping outputs 3 rows.

Explain Dataware house architecture .how data flow from intial to end?

2530

---

Design a mapping to load a target table with the following values from the above source?

1289

---

what is the hint? how to use it to reduce the query processing in program?

7634

---

What are the new features of informatica 9.x developer?

903

---

What is a standalone command task?

1142

---

Explain pmcmd command usage in informatica

1068

---

What are the different clients of powercenter?

1006

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1028

---

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

1054

---

What's the layout of parameter file (what does a parameter file contain?)?

2337

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1888

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1104

---

How to configure mapping in informatica?

1122

---

Why update strategy and union transformations are active? Explain with examples.

1176

---

How can we use mapping variables in informatica? Where do we use them?

1101

---