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
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
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How do you load alternate records into different tables through mapping flow?
What is dimensional table?
How is union transformation utilized?
According to his methodology what all you need before you build a datawarehouse
Which transformation should we use to normalise the COBOL and relational sources?
State the limitations where we cannot use joiner in the mapping pipeline?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Tell me about MD5 functions in informatica
in reporting we add some new objects,how we get the count of the newly added objects to the report
design of staging area?
What you know about transaction control transformation?
Explain constraint based loading in informatica
Which version configuration tool used in ur project?