Interested to Buy Any Domain ? << Click Here >> for more details...
What is constraint based loading exatly? And how to do this?
I think it is when we have primary key-foreign key relation
ship. Is it correct?
please answer me.
Advance Thanks.
- 4 Answers
- 7366 Views
- I also Faced
- E-Mail Answers
Answer Posted / om
Constraint Based Load order defines load the data into
multiple targets depend on the primay key foriegn key reltion.
set the option is: Double click the session
Configue Object check the Constraint Based Loading
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
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 informatica metadata?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is joiner transformation in informatica?
What are the steps involved in the migration from older version to newer version of Informatica Server?
define galaxy repository in informatica
What are the transformations that are not supported in mapplet?
wf dont have integration severances how you can run?
Mention few power centre client applications with their basic purpose?
What is the difference between STOP and ABORT options in Workflow Monitor?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is meant by incremental aggregation?
