Answer Posted / jaspreet banga

after source qualifier, Use an expression transformer , in
that take an variable port name 'FLAG', and in that use the
decode function as 'FLAG = DECODE(GENDER=MALE,'M','F')'.
after that place an router transformer and for each flag
condition use seperate instance of target and hence you
will get what you want.

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

2059

---

Explain in detail about scd type 1 through mapping.

1630

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1960

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1714

---

Under which circumstances, informatica server creates reject files?

1142

---

What are the types of caches in lookup? Explain them.

1013

---

What is the difference between a connected look up and unconnected lookup?

1003

---

What is an Integration service in Informatica?

1191

---

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

1163

---

Explain sessions and how many types of sessions are there?

1059

---

What is domain and gateway node?

1208

---

Explain pmcmd command usage in informatica

1189

---

What are the different transaction levels available in transaction control transformation?

1275

---

how we can load rejected record's at run time?(not through bad files)

2431

---

What is a pre-defined event and user-defined event?

1083

---