How can you change from reusable session into non-reusable
session.
Answer Posted / amedela chandra sekhar
If u devlope the session in work flow manager that is
standlone session.that is not reusable first.we can't
achieve if you create session in work flow.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain in detail about scd type 1 through mapping.
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 do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What do you understand by term role-playing dimension?
What are roles and groups and benefits of using them?
What does cheating measurement mean?
What do think which one is the better joiner or look up?
What are the differences between oltp and olap?
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 is xml source qualifier transformation in informatica?
What is mapping debugger?
What are the new features of informatica 9.x in developer level?
How do you update the records with or without using update strategy?
Differentiate between reusable transformation and mapplet.
Did u used latest transformations of 8.6.0? for what?