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

what is difference between COM & DCOM?

1 Answers   Satyam,

can any one give some examples for pre sql and post sql(Except dropping and creating index).

0 Answers   Zensar,

What is active and passive transformation?

10 Answers  

Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,

Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

How to generate the HTML output using Informatica.

3 Answers   Wipro,

source table have 3 records? and it is sucessfully loaded into target. and 4more records is added in to source .that means 7 records now in source. we have to load the remaining 4 records into the same trgt table with maintian top 3 records. how ?can any one give me the data flow of this logic plz?

5 Answers   Wipro,

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

How informatica process data means how informatica works?

2 Answers   TCS,

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,

For more Informatica Interview Questions Click Here
Categories