Answer Posted / john
if u have 2 or 3 pipelines in your mapping,which pipeline
will load first?
so taget load plan option will give u the availability of
which pipeline will load first and then which one is second
u can decide based on requirement or your logic.
if u doesn't give tagetload planing option,informatica server
will load the pipelines one by one but how it will take we
don't know.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
what is the size of your data warehousing?
EXL informatica Questions
What is a standalone command task?
What is Cognos script editor?
Separate from a database, an information bazaar, and an information stockroom?
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?
Please let me know how to make Data masking in informatica..
What are the advantages of using informatica as an etl tool over teradata?
What is mapplet in informatica?
Explain lookup transformation source types in informatica
Which files are created during the session rums by informatics server?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
How can we delete duplicate rows from flat files?
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