Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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 are the uses of a Parameter file?

3 Answers   CSC,

Can we get 1st record through Informatica(without sequence number).

0 Answers  

Sequence generator, when you move from develoment to production how will you reset

0 Answers  

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?

0 Answers  

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.

9 Answers   Barclays,

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

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?

6 Answers   TCS,

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

0 Answers   TCS,

If we are using an aggregator but forget to mention the group by port .what will be the output??

11 Answers   Nomura, TCS,

write a query to get maximum salary from the employers table without duplicates....kindly help me

5 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories