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

My source is like bellow
F.NAME M.NAME L.NAME
A B C
D E F
G H I

and out put should like

S.NO F.NAME M.NAME L.NAME
1 A B C
2 D E F
3 G H I
4 UNNOWN UNNOWN UNNOWN

How can we acheive? please explane me indetail

Question Posted / santosh

2 Answers
6775 Views
Amdocs, I also Faced
E-Mail Answers

Answer Posted / 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);

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Clarify the utilization of aggregator cache record?

998

Explain lookup transformation source types in informatica

1096

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2120

What do you mean by channel change?

1041

What is sorter transformation?

1045

How is union transformation utilized?

1009

How can you validate all mappings in the repository simultaneously?

1369

Briefly define a session task?

1130

What is parallel processing in informatica?

1711

What are Dimensional table?

1053

How do you handle two sessions in Informatica

1162

Is stop and abort are same in informatica?

1000

What is the procedure for creating independent data marts from informatica 7.1?

1064

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

1032

Explain joiner transformation in informatica

1124