Answer Posted / shiva

simply connect source to target

but be very careful with the connections from source to
target

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 .

1939

---

Explain about cumulative Sum or moving sum?

1037

---

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?

968

---

What is domain in terms of informatica?

1000

---

how to load dimension table and fact table. plz tell me the steps.

2092

---

Define mapping and session?

1032

---

What is the command used to run a batch?

1058

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1261

---

What happens when a session fails and you click on recover?

1116

---

What is sequence generator transformation in informatica?

1072

---

What is an unconnected transformation?

1080

---

How to go to the older version for a mapping?

1094

---

What are the informatica performance improvement tips

1087

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8112

---

Can we change Dynamic to Static or Persistent cache? If so what happens?

2203

---