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

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision

2 Answers  

What is a look up function? What is default transformation for the look up function?

2 Answers   ASM, TCS,

What is IQD file?

1 Answers  

Explain pmcmd command usage in informatica

0 Answers   Informatica,

What is a filter transformation and why it is an active one?

0 Answers  

Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,

What is complex mapping?

0 Answers  

How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important

4 Answers   CTS,

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

What is blocking transformation?

0 Answers   Informatica,

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

0 Answers   TCS, Wipro,

For more Informatica Interview Questions Click Here
Categories