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 are teh different tasks that can be created in workflow manager?

1 Answers   NIIT,

what is the monster dimension plz give me one example

2 Answers   EDS,

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

What is source qualifier transformation?

1 Answers  

Why filter transformation is an active one?

0 Answers  

what is update strategy transformation ?

7 Answers   TCS,

What is intricate mapping?

0 Answers  

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers   IBM,

Why do you use Mapping Parameter and mapping variable?

0 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?

9 Answers   Target,

For more Informatica Interview Questions Click Here
Categories