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

Explain the tuning lookup transformation - informatica

0 Answers   Informatica,

how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.

5 Answers   Keane India Ltd,

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

What are active transformations.

0 Answers  

How are indexes created after completing the load process?

0 Answers  

What are conformed dimensions?

1 Answers  

What do you mean incremental aggregation?

0 Answers  

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

What is meant by lookup transformation? Explain the types of lookup transformation?

0 Answers  

how to get max value record into one target and remaining records into another target?

2 Answers   Accenture,

If you want to create indexes after the load process which transformation you choose?

3 Answers   HCL,

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

5 Answers   Polaris, Zensar,

For more Informatica Interview Questions Click Here
Categories