What is batch and describe about types of batches?
Answer Posted / swetha
Grouping of session is known as batch.Batches are two types
Sequential: Runs sessions one after the other
Concurrent: Runs session at same time.
If you have sessions with source-target dependencies you
have to go for sequential batch to start the sessions one
after another.If you have several independent sessions you
can use concurrent batches Which runs all the sessions at
the same time.
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Enterprise data warehouse your projects phase by phase explain?
What is dimensional table? Explain the different dimensions.
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?
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
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How to create the source and target database connections in server manager?
Can u generate reports in Informatica?
What is a predefined event?
Mention few power centre client applications with their basic purpose?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
How to update or delete the rows in a target, which do not have key fields?
What is an unconnected transformation?
What are mapplets?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?