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
- 6893 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
What are the components of workflow manager?
tell me about your project functionality
What is the difference between STOP and ABORT options in Workflow Monitor?
which one is better performance wise joiner or look up
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between joiner and lookup transformation?
What is a surrogate key?
Why update strategy and union transformations are active?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How are indexes created after completing the load process?
What is workflow? What are the components of the workflow manager?
write a query to retrieve the latest records from the table sorted by version(scd)
differences between service based and product based?
Different circumstance which drives informatica server to expel records?
What is olap (on-line analytical processing?
