why not? If you use a xml file or a VSM(cobol) file u will not have a sourc

Can we have a Mapping without a Source Qualifier?

Question Posted / rj

14 Answers
49283 Views
Deloitte, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Did u used latest transformations of 8.6.0? for what?

1822

CANNOT USE PARAMETER FILE! Hi all, I am trying to use parameter file for my workflow. This could help me to filter records where CITY = 'Portland' Following is what I have done: **in Designer - create new parameter : $$PARA_FIL, Parameter, String, IsExprVar=TRUE, Initial value = [empty] - Source Qualifier/ Properties/Source Filter: CUSTOMERS.CITY='$$PARA_FIL' **Create Parameter file: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt $$PARA_FIL='Portland' **Configure workflow to use the parameter file: Edit Workflow/Properties/Parameter Filename: C:\Informatica\PowerCenter8.6.0 \server\infa_shared\BWParam\DynamicParamTest.txt I also configured directory of parameter file for session task. However, I just got this in the session log: [SQ_CUSTOMERS] SQL Query [SELECT CUSTOMERS.CUSTOMER_ID FROM CUSTOMERS WHERE CUSTOMERS.CITY='$$PARA_FIL'] No record has been loaded to target. It seems that the parameter file has not been read. I cannot understand the reason why. Could any of you kindly suggest me anything? Thanks

8935

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

997

how many types of dimensions are available in informatica?

996

What do you understand by SOA of Informatica?

921

What is a filter transformation and why it is an active one?

905

What is informatica powercenter repository?

1139

Why sorter is an active transformation?

1130

How will the document be delivered to me?

1017

How do you load alternate records into different tables through mapping flow?

1801

Define sessions in informatica etl?

964

How might you approve all mappings in the archive all the while?

955

What are the main issues while working with flat files as source and as targets ?

1094

What is domain and gateway node?

1118

What is a sorter transformation?

1033