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

I have source like col1,col2,col3,col4 and the values are like
3,6,1,7
1,5,3,8
2,1,5,6

i want the output like
3,6,7
5,3,8
2,5,6

How we will achieve in this scenario in informatica level.
Please help me..

Thanks in advance..




Question Posted / chandranmca2007

Answers were Sorted based on User's Feedback



I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want ..

Answer / vidya

source -- sq -- exp1 -- exp2 -- t

exp1- create 4 var ports, and 1 output port as
v1=iif(col1=1, null, c1)
v2=iif(col2=1, null, c2)
v3=iif(col3=1, null, c3)
v4=iif(col4=1, null, c4)
op_port1=v1||v2||v3||v4
exp2- op_port1
create 3 out_put port
c1=substr(op_port1, 1,1)
c2=substr(op_port1, 2,1)
c3=substr(op_port1, 3,1)

Is This Answer Correct ?    10 Yes 0 No

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want ..

Answer / bharath

i don't know in informatica
in general approach,
concatenate all the columns into one column and strip the 1s
to empty string("")
and then seperate to each column one number on each column.

i hope it helps to u.


cheers!

Is This Answer Correct ?    2 Yes 0 No

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want ..

Answer / davan

Its not a proper ???.there is no logic in ????.

Is This Answer Correct ?    0 Yes 0 No

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want ..

Answer / krishna prasad

use the filter transformation

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers   HCL, HP,

How to delete duplicate records in a flat file source?

2 Answers  

what r the transformations that r not involved in mapplet?

8 Answers   Wipro,

My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….

7 Answers   Accenture,

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,

What are the mapping parameters and mapping variables?

0 Answers   Informatica,

Is informatica power center designer has 64 bit support?

1 Answers  

What are session parameters ? How do you set them?

0 Answers  

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

0 Answers  

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

what is mapping optimization? wat are the techniques for tat

2 Answers  

For more Informatica Interview Questions Click Here
Categories