Interested to Buy Any Domain ? << Click Here >> for more details...
What are the different options used to configure the
sequential batches?
- 2 Answers
- 9206 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / swetha
Two options
Run the session only if previous session completes
sucessfully. Always runs the session.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the need of etl tools?
What are roles and groups and benefits of using them?
What is a repository manager?
In informatica workflow manager, how many repositories can be created?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
is it possible to index the data in cache of lkp transformation ?
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.
How can repository reports be accessed without sql or other transformations?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
what is degenerated dimension?
What is dimensional table? Explain the different dimensions.
How do you set a varible in incremental aggregation
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
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
