Answer Posted / abhishek upadhyay

It can be done easily by a SQ generator....The SQ generator
will assign the number as a PK to all the rows.

1
2
3
4
5.... and so on

Now when this is done you can write in the post target sql
that -

delete from target table where number <>1 or number <> 5

and then the target table will be left with only 1 and 5
records

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2510

---

Explain the difference between mapping parameter and mapping variable?

1079

---

What is difference between a gateway node and worker node?

1201

---

What is an aggregator transformation?

1142

---

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 .

1986

---

What are the differences between joiner transformation and source qualifier transformation?

1235

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1170

---

What is the meaning of decode in informatica?

1164

---

How does a rank transform differ from aggregator transform functions max and min?

1261

---

What is a joiner transformation and why it is an active one?

1163

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1096

---

what is SDLC way of code development?

2091

---

have u done any performance tuning? how u ll do?

2362

---

What all join we can perform in LOOKUP transformation?

1019

---

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

---