Answer Posted / venkatesh.malneni

let us take the metadata as name and records ok,
in expression t/r we create a new o/p port in that write the
expression as name ||''||record||''||records||''|| times


connect the newly created o/p port to the target.

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2166

---

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?

978

---

What is primary and backup node?

1137

---

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

2389

---

What is complex mapping?

1127

---

How do you take back up of repository?

1162

---

Different circumstance which drives informatica server to expel records?

985

---

How do you load first and last records into target table?

1160

---

Explain the tuning lookup transformation - informatica

998

---

How to load the name of the current processing flat file along with the data into the target using informatica mapping?

1280

---

What are the tasks that can be performed using sq?

1096

---

scenario where i can use only concurrent execution of workflow.

3180

---

Can we override a native sql query within informatica?

1045

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2011

---

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 .

1948

---