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

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104
MY REQUIRMENT IS
NAME ID
VENKATESH 101
RAJESH 102
SIVA 103
SWATHI 104

PLEASE PROVIDE ME THE SOLUTION

Question Posted / venki.malneni

Answers were Sorted based on User's Feedback



MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ..

Answer / saket

Separate VENKATESH ,101
Rajesh,102
Siva ,103 by using "||" as delimiter .


Then in the expression Divide the string Venkatesh ,101 intto two separate variable using string operation and output that two separate columns of the target

Is This Answer Correct ?    2 Yes 0 No

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ..

Answer / sreekanth

when at the time of this kind of situation we can normally
import the source definitions by treat consecutive
delimiters as one and use the normalizer transformation and
set occurenc
as one and connect those ports to next transformations.

Is This Answer Correct ?    1 Yes 0 No

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ..

Answer / vijaya

two types
treat consecutive delimiters as one in import from flat file
then use a normalizer transformation you will get the answer

second type in unix scripting you can get the o/p

Is This Answer Correct ?    1 Yes 1 No

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ..

Answer / venkateshmalneni

hai vijaya


will u please explain me in detail

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?

18 Answers   L&T,

Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2 Answers  

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

0 Answers   Wipro,

What do you mean by enterprise data warehousing?

0 Answers  

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

I have a scenario which load the data frm single source to 2 targets as T1, T2, and T1 have a P.K and T2 have F.K relations. first data has to load in T2, and then data load to T1 if that record exist in T1... how can we acheive it?

2 Answers   Ness Technologies,

How to load the data from people soft hrm to people soft erm using informatica?

0 Answers  

If a table contains 100 records we have to fetch 50-100 records from source to target?how

7 Answers   CSC,

can we use cartesian join in informatica

3 Answers   IBM,

what is dynamic cashe

3 Answers   Informatica,

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

Explain the different kinds of facts.

0 Answers  

For more Informatica Interview Questions Click Here
Categories