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

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?

4 Answers  

Can anyone guide me the steps to install informatica PC 8.5.1 with database as oracle

1 Answers  

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID anil643@gmail.com (or) kumar643@gmail.com

0 Answers  

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

0 Answers   Wipro,

get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

0 Answers  

Explain sessions. Explain how batches are used to combine executions?

0 Answers  

For more Informatica Interview Questions Click Here
Categories