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
- 6785 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 is rank transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can we get 1st record through Informatica(without sequence number).
What is informatica worklet?
What is persistent lookup cache?
Differentiate between sessions and batches?
complex mapping ur project u r invlve can u explain and give real time example give me ?
In how many ways we can create ports?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
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
How to generate or load values in to the target table based on a column value using informatica etl tool.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is the use of an aggregator cache file?
What is lookup transformation?
