Answer Posted / siva

Use 2 variables one for counter and another for value.
sort all the records by c1 and keep track on c1 and hold
the value in v1. When the v1 and c1 are equal, then
concatenate c2 with v2 other assign c2 with v2. Finaly
connct to aggregator and take last value by grouping the
records by c1.


This will work..

How to generate sequence numbers using expression transformation?

1036

---

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 .

1899

---

Define mapping and session?

985

---

Design time, run time. If you don't create parameter what will happen

1806

---

How to create the source and target database connections in server manager?

1048

---

What is a dimensional model?

941

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6381

---

Why union transformation is an active transformation?

1003

---

How many ways a relational source definition can be updated and what are they?

969

---

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

1995

---

tell me about your project functionality

2309

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1641

---

How to delete duplicate row using informatica?

992

---

What is informatica etl tool?

956

---

How to convert multiple rows to single row (multiple columns) in informatica

1331

---