can we import source table without using source qualifier? if
yes then how? if no then why?
- 2 Answers
- 10153 Views
- Thomson Reuters, I also Faced
- E-Mail Answers
Answer Posted / james
Yes.
For cobol file sources we can directly use normalizer t/r
without using source qualifier
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What if the source is a flat-file?
What is a sequence generator transformation?
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
What is a rank transform?
what is SDLC way of code development?
Make a note of the quantity vaults made in informatica?
What are ETL Tools?
What is the format of informatica objects in a repository?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What does update strategy mean, and what are the different option of it?
What are batches?
Define Pmrep command?
As union transformation gives UNION ALL output, how you will get the UNION output?
What does “tail –f” command do and what is its use as an Informatica admin.
Explain in detail scd type 2 through mapping.
