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
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
What are the basic requirements to join two sources in a source qualifier transformation using default join?
How can we delete duplicate rows from flat files?
How to load the data from a flat file into the target where the source flat file name changes daily?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is informatica worklet?
What are the designer tools for creating transformations?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
When do you use sql override in a lookup transformation?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What is target designer and target load order?
How many types of sessions are there in informatica.please explain them?
How can you differentiate between powercenter and power map?
Explain joiner transformation in informatica
Name the different lookup cache(s)?
What are batches?