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 |
How to eliminate duplicate records in informatica mapping? Explain with an example....
Explain Dataware house architecture .how data flow from intial to end?
when i try to connect to the repository server i am getting this message can someone help me.. Starting Repository [infa_rep] (6016|1292) Informatica Repository Agent, version [7.1.1], build [0811], 32-bit. (6016|1292) Copyright (c) 2000-2004 Informatica Corporation. All Rights Reserved. This Software is protected by U.S. Patent Numbers 6,208,990; 6,044,374; 6,014,670; 6,032,158; 5,794,246; 6,339,775 and other U.S. Patents Pending. (6016|1292) Informatica Repository Agent starting up. (6016|1292) Security audit trail has been turned off. (6016|1292) infa_rep: Repository runtime manager initialized. (6016|1292) infa_rep: Initialized configuration information. (6016|1292) infa_rep: Initialized request dispatcher. (6016|1292) Database Connection Error : Failed to logon to Database server ORA-12154: TNS:could not resolve service name Database driver error... Function Name : Connect Database Error: Failed to connect to database using user [] and connection string []. (6016|1292) Service stopped.
What is the surrogate key?
lookup transformation with screenshots
What is query panel?
how we load the data from source to staging area
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
what are surrogate keys?
Can a joiner be used in a mapplet.
What are the types of data that passes between informatica server and stored procedure?
What is the use of code page?