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
Answers were Sorted based on User's Feedback
Answer / raghava
Use following steps to compleate the task.
Step:I
Use an expression transformation.In the experssion
transformation crate output ports for each inputport.
In current examle:
out_F.NAME=IIF(NOT ISNULL(F.NAME),F.NAME.'UNNOWN')
out_M.NAME=IIF(NOT ISNULL(M.NAME),M.NAME.'UNNOWN')
OUT_L.NAME=IIF(NOT ISNULL(L.NAME),L.NAME.'UNNOWN')
Step:II
Create Sequence Generator transformation .Connect NEXTVAL
port of Sequence Generator transformation to S.NO in targt
Step:III
Connect out_F.NAME-->F.NAME in target
out_M.NAME-->M.NAME in target
out_L.NAME-->M.NAME in target
| Is This Answer Correct ? | 9 Yes | 1 No |
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
How are indexes created after completing the load process?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is blocking transformation?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
what are challenges that you faced in testing? give solution to it?
Roles and Responsibilties of Informatica Production Support Member?
How can you increase the performance in joiner transformation?
Repository user profiles
difference between source based commit? and target based commit? which is better with respect to performance?
How can you access the remote source into your session?
In informatics server which files are created during the session rums?