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

What are the basic needs to join two sources in a source qualifier?

4 Answers  

what are the unix commands to start the wrk flow ?

4 Answers   Accenture, TCS,

How you count the number of records available at your source?

3 Answers   Zensar,

How can you complete unrcoverable sessions?

1 Answers  

in which situations do u go for snowflake schema ?

2 Answers   TCS,

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

How can you access the remote source into your session?

1 Answers  

following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?

2 Answers   Patni,

Can we change Dynamic to Static or Persistent cache? If so what happens?

0 Answers   TCS,

what is the method of error handling when session is running?

1 Answers   TCS,

How to read data from flat file source if the data is in paragraph format?

2 Answers   Wipro,

If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories