can we import source table without using source qualifier? if
yes then how? if no then why?

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


Please Help Members By Posting Answers For Below Questions

What if the source is a flat-file?

855


What is a sequence generator transformation?

802


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

8501


What is a rank transform?

878


what is SDLC way of code development?

1799


Make a note of the quantity vaults made in informatica?

794


What are ETL Tools?

874


What is the format of informatica objects in a repository?

826


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.

2081


What does update strategy mean, and what are the different option of it?

870


What are batches?

832


Define Pmrep command?

852


As union transformation gives UNION ALL output, how you will get the UNION output?

894


What does “tail –f” command do and what is its use as an Informatica admin.

869


Explain in detail scd type 2 through mapping.

861