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

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

What are reusable transformations in how many ways we can create them?

2 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,




wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

if the session fails after 100 records agian we have to starts the session or we go for recovery session

2 Answers   TCS,

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers   Cognizant, emc2,

source file name xyz a,0,a,a,a b,b,b,0,b c,c,c,0,c target should be like this xyz a b c how to implement this?

4 Answers   Polaris,

Can we update the data in flat file using update strategy?

3 Answers  

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

What are set operators in Oracle

3 Answers   Deloitte, Wipro,

For more Informatica Interview Questions Click Here
Categories