Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 6631 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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
Define joiner transformation?
What differs when we choose the sorted input for aggregator transformation?
What are the transformations that are not supported in mapplet?
What is the difference between a repository server and a powerhouse?
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 are the differences between source qualifier and joiner transformation?
What are the tuning techniques you applied during your last project
How do we call shell scripts from informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How can we delete duplicate rows from flat files?
How do you load only null records into target? Explain through mapping flow.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Define filter transformation?
