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
- 6632 Views
- Amdocs, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is a sorter transformation?
In informatics server which files are created during the session rums?
what is the complex transformation you used in informatica
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. ?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
What is complex mapping?
How to load last n records of file into target table - informatica
What is data transformation manager process?
What is a stored procedure transformation?
Write the unconnected lookup syntax and how to return more than one column.
Explain what are the different types of transformation available in informatica.
What all join we can perform in LOOKUP transformation?
Define pmcmd command?
What is sequence generator transformation in informatica?
