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

source table have single column single record having with
single space.
load that source record into trg . trgt having two columns
and the
SOURCE TABLE LIKE

COL1
BHANU PRASAD
TRGT TABLE
COL1 COL2
IN THAT LOAD THE RECORD IN THE trgt table LIKE
COL1 COL2
BHANU PRASAD
HOW ? TELL ME PLZ

Question Posted / sbvp

Answers were Sorted based on User's Feedback



source table have single column single record having with single space. load that source record i..

Answer / suraj kedia

Let our source table name is "Name",which is having COL1 and
data in it is BHANU PRASAD (For easier understanding instead
of space between bhanu and prasad,lets take a underscore
i.e. BHANU_PRASAD.

Source ----> Exp t/r ----> target
In the exp t/r take "name" as an input port only and create
2 out put ports as COL1 and COL2.
In COL1 give condition
substr(Name,1,instr(Name,'_',1)-1)

In COL2 give condition
substr(Name,instr(Name,'_',1)+1)


now connect COL1 port form exp to COL1 port in tgt and same
for COL2, than the out put in the target table will be as below:

COL1 COL2
BHANU PRASAD

Is This Answer Correct ?    14 Yes 1 No

source table have single column single record having with single space. load that source record i..

Answer / raj

Nice answer keeep it up

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

What is rank transformation?

0 Answers  

Explain about perform recovery?

1 Answers  

Is there any model difference between ODS and DWH

2 Answers   Zensar,

where to select code page option?

2 Answers   TCS,

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,

What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

What is the difference Between Mapping parameter and variable

3 Answers   Accenture,

what is meant by lookup caches?

2 Answers   Cap Gemini, Informatica,

What is target load order?

0 Answers  

How to extract sap data using informatica?

0 Answers  

For more Informatica Interview Questions Click Here
Categories