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

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

How are indexes created after completing the load process?

0 Answers  

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

What is blocking transformation?

0 Answers   Informatica,

is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?

3 Answers   IBM,

what are challenges that you faced in testing? give solution to it?

1 Answers  

Roles and Responsibilties of Informatica Production Support Member?

6 Answers  

How can you increase the performance in joiner transformation?

0 Answers  

Repository user profiles

0 Answers  

difference between source based commit? and target based commit? which is better with respect to performance?

6 Answers   IBM,

How can you access the remote source into your session?

1 Answers  

In informatics server which files are created during the session rums?

0 Answers  

For more Informatica Interview Questions Click Here
Categories