Mapplets ( can you use source qyalifier, can you use sequence generator, can you use target)
Answer Posted / isha
Among these three, you can only use seq generator (only reusable sequence generator)
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you define user defied event?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is a grid in Informatica?
Explain the types of transformations?
What are mapplets?
What are the steps involved in the migration from older version to newer version of Informatica Server?
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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is a connected transformation?
What is rank index in rank transformation?
Define update strategy?
What is pmcmd command?
What is meant by incremental aggregation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is Cognos script editor?