Can we have a Mapping without a Source Qualifier?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Answer / sj
sorry guys i wrote the answer wrong.It's not possible with out sq.
Is This Answer Correct ? | 5 Yes | 5 No |
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 |
What is the difference between Bulk Load and Normal Load
what is confirmed dimension?
What is an expression transformation in informatica?
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
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
Name 4 output files that informatica server creates during session running?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
Why we require dwh in particular projects?
what type of problem you faced insales project or insurance project
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
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!!
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files