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
- 6786 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
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
How big was your fact table
What is the status code in stored procedure transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is flashback table ? Advance thanks
What are the types of presistent cache in look up tr.
Did u used latest transformations of 8.6.0? for what?
How are the sources and targets definitions imported in informatica designer?
what is the difference between informatica6.1 and infomatica7.1
What is meant by incremental aggregation?
What is the Rank index port in Rank transformation?
What is dimensional table?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How do you load first and last records into target table?
