Answer / raghava

Use following steps to compleate the task.

Step:I

Use an expression transformation.In the experssion
transformation crate output ports for each inputport.

In current examle:
out_F.NAME=IIF(NOT ISNULL(F.NAME),F.NAME.'UNNOWN')
out_M.NAME=IIF(NOT ISNULL(M.NAME),M.NAME.'UNNOWN')
OUT_L.NAME=IIF(NOT ISNULL(L.NAME),L.NAME.'UNNOWN')

Step:II

Create Sequence Generator transformation .Connect NEXTVAL
port of Sequence Generator transformation to S.NO in targt

Step:III

Connect out_F.NAME-->F.NAME in target
out_M.NAME-->M.NAME in target
out_L.NAME-->M.NAME in target

Answer / santosh

if target is a database the you can write post sql in session to the result as below

insert into table_name values((select max(s.no)+1 from table_name),'UNKNOWN','UNKNOWN',UNKNOWN);

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

---

If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?

1 Answers   Amdocs,

---

Have you worked with/created Parameter file

0 Answers  

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

how tokens will generate?

0 Answers  

---

What are the types of maping in Getting Started Wizard?

1 Answers  

---

Define sessions in informatica etl?

0 Answers  

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

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?

0 Answers  

---

What are the data movement modes in informatcia?

3 Answers  

---