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 |
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What is query panel?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
how many ways can we implement SCD2?
How to update or delete the rows in a target, which do not have key fields?
How to list Top 10 salary, without using Rank Transmission?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????
what is diffrence b/w joner and union transfermation
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
What are the different transaction levels available in transaction control transformation?