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

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

what are the types of facts with Examples?

3 Answers  

we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks

3 Answers   TCS,

How does the aggregator transformation handle null values?

0 Answers  

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

Explain what are the different versions of informatica?

0 Answers  

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

Explain the aggregator transformation?

0 Answers  

Can you start a session inside a batch individually?

2 Answers  

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories