Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 49294 Views
- Deloitte, I also Faced
- E-Mail Answers
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 ? | 33 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 ? | 17 Yes | 11 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 ? | 3 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 | 6 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 |
How to load a Dimension ? and how to load a fact table?
Is it possible to define a single node as a Gateway node as well as worker node?
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
HOW DO YOU CONNECT TO REMOTE SERVER ?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
what is normalizer transformation?
Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.
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
what are the unix commands to start the wrk flow ?
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
what is Partitioning ? where we can use Partition?
What is a filter transformation?
Teradata 
