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
- 6692 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 databases that informatica can connect to windows?
Why is sorter an active transformation?
What does “tail –f” command do and what is its use as an Informatica admin.
How to improve the performance of a session using sorter transformation?
How to create Target definition for flat files?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Which files are created during the session rums by informatics server?
What is sq transformation?
What does refresh system mean, and what are its distinctive choice?
is it possible to index the data in cache of lkp transformation ?
Explain what transformation and how many are there in informatica?
Scheduling properties,whats the default (sequential)
What is standalone command task?
What are the tuning techniques you applied during your last project
