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...


Can we have a Mapping without a Source Qualifier?

Answers were Sorted based on User's Feedback



Can we have a Mapping without a Source Qualifier?..

Answer / rj

why not? If you use a xml file or a VSM(cobol) file u will not have a source qualifier

Is This Answer Correct ?    33 Yes 2 No

Can we have a Mapping without a Source Qualifier?..

Answer / arnab

yes it is possible , if you have cobol source files
you will not have a source qualifier but instead
a normalizer

Is This Answer Correct ?    27 Yes 2 No

Can we have a Mapping without a Source Qualifier?..

Answer / ashish

In addition to the Aruna's answer,Integration service require native datatypes and SQ convert the port in to native datatypes to make the data compatible with Integration service.
for Eg. In source table if a column's datatype is "Varchar2" then source qualifier will convert it in "String" type.

Is This Answer Correct ?    23 Yes 6 No

Can we have a Mapping without a Source Qualifier?..

Answer / aruna1105

No. Source qualifier is required to make the data compatible with Informatica. It basically qualifies the data to a language which informatica can understand.

Is This Answer Correct ?    17 Yes 11 No

Can we have a Mapping without a Source Qualifier?..

Answer / babu

Hi All,
It can be possible,whenever u r source is COBAL FILE at
that time NORMALIZER T/R ACTS AS A SQ.

Is This Answer Correct ?    7 Yes 1 No

Can we have a Mapping without a Source Qualifier?..

Answer / amit

Yes it is very much possible to have a mapping without a
source qualfier...If you have COBOL source files you will
NOT have a source qualifier , you will have a Normalizer
instead..

Is This Answer Correct ?    5 Yes 1 No

Can we have a Mapping without a Source Qualifier?..

Answer / varun dikshit

What If we connect a sequence generator directly to target? No SQ required in such a case :)

Is This Answer Correct ?    3 Yes 1 No

Can we have a Mapping without a Source Qualifier?..

Answer / kapil

In case of XML files, it's called as XML source qualifier.
So we can't have mapping without SQ.

Is This Answer Correct ?    4 Yes 3 No

Can we have a Mapping without a Source Qualifier?..

Answer / sj

sorry guys i wrote the answer wrong.It's not possible with out sq.

Is This Answer Correct ?    5 Yes 6 No

Can we have a Mapping without a Source Qualifier?..

Answer / ankit

i guess u can just create stored procedure transformation
without any source in mapping or target in mapping...define
connection in session...i haven't tried this...i haven't
lost my nutts yet

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

How we can confirm all mappings in the repository simultaneously?

1 Answers  


what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


why we use stored procedure transformation?

4 Answers   IBM,


What all join we can perform in LOOKUP transformation?

0 Answers  


What is exclusive and normal mode for repository services?

0 Answers  


Informatica and datawarehousing courses in Pune?

2 Answers  


What is different between informatica version 8 and 9 version

1 Answers   Cognizant, IBM,


How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,


Can we override a native sql query within informatica?

0 Answers  


what is upstream and downstream transformation?

7 Answers  


What is the Rankindex in Ranktransformation?

7 Answers  


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

0 Answers  


Categories