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

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?

Question Posted / siva

Answers were Sorted based on User's Feedback



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 ..

Answer / dbloc

Based on the data structure, there are 3 rows present. The
clear indicator here is that the last character of each row
does not have a comma.

A sorter (as previously answered will not handle this using
it's DISTINCT option because each row is distinct. The
previous Normalizer answer just baffles me.

Simple answer: Connect to an expression and only connect
the first port of the record to the target.

a
b
c

Keep it simple.

Is This Answer Correct ?    9 Yes 0 No

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 ..

Answer / dilip ingole

don't specify delimiter while importing file and use similar function in informticw as

SELECT substr(REGEXP_REPLACE('a,0,a,a,a','[^[:alpha:]]',''),1,1) FROM DUAL;

Is This Answer Correct ?    0 Yes 1 No

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 ..

Answer / rajesh

use normalizer trans,then give condition input 5,output 1 as
accurs 5,resulting all columns in single column as manay as rows

Is This Answer Correct ?    0 Yes 3 No

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 ..

Answer / amedela chandra sekhar

By using sorter t/r select distinct option
it eliminate the duplicates.

Is This Answer Correct ?    0 Yes 8 No

Post New Answer

More Informatica Interview Questions

What is the meaning of up gradation of repository?

0 Answers  

what we require for D.modelling?

1 Answers  

Why we need XMLs?

3 Answers   IBM,

My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...

2 Answers   Accenture,

My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.

4 Answers  

How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?

3 Answers   Logica CMG,

wt is informatica file watch timers in aflat i want to get the first record and last record how could i.

1 Answers   CTS,

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

0 Answers  

What are the performance considerations when working with aggregator transformation?

0 Answers  

What are partitions in informatica and which one is used for better performance?

2 Answers  

For more Informatica Interview Questions Click Here
Categories