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 ?    32 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 ?    16 Yes 10 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 / 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 / varun dikshit

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

Is This Answer Correct ?    2 Yes 1 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 5 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

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,


what is confirmed dimension?

6 Answers  


What is an expression transformation in informatica?

0 Answers  


i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,


supose if ur scr table contains alphanumeric values like 1,2,3,a,v,c in one columen like c1 n now u have load d data in 2 seperare columns like ID should contain only numbers 1,2,3 n NAME col should contain a,b,cin target?How

4 Answers   TCS, Wipro,






Name 4 output files that informatica server creates during session running?

1 Answers  


what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy

2 Answers   TCS,


Why we require dwh in particular projects?

1 Answers   Amdocs,


what type of problem you faced insales project or insurance project

1 Answers   Sony,


How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.

1 Answers   Cognizant,


Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  


Categories