1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

Answers were Sorted based on User's Feedback



My source is like bellow F.NAME M.NAME L.NAME A B C D E F G ..

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

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G ..

Answer / santosh

if target is a database the you can write post sql in session to the result as below

insert into table_name values((select max(s.no)+1 from table_name),'UNKNOWN','UNKNOWN',UNKNOWN);

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More Informatica Interview Questions

Explain pmcmd command usage in informatica

0 Answers   Informatica,

How we can use union transformation?

0 Answers  

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

how we can add header and footer to flat files?

2 Answers   Tech Mahindra, Zensar,




how to get flatfile containg 10 records half records one target another half another target

2 Answers  

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers   Axtria,

design of staging area?

0 Answers  

What is the use of target designer?

0 Answers  

hw cn v elimate dublicate values from lookup without overriding sql?

7 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories