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 |
What are the uses of a Parameter file?
Can we get 1st record through Informatica(without sequence number).
Sequence generator, when you move from develoment to production how will you reset
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
How can you change from reusable session into non-reusable session.
without dynamic lookup how to insert new rows and update existing rows?
how to run workflow in unix?
5 Answers Colgate, HP, Tech Mahindra,
which is better perfomancewise lookup or joiner and why?can anyone give example?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
If we are using an aggregator but forget to mention the group by port .what will be the output??
write a query to get maximum salary from the employers table without duplicates....kindly help me