Interested to Buy Any Domain ? << Click Here >> for more details...
3. Suppose Seq Gen is supplying a increamental value to a column
of a table, suppose, table's column value reaches to maximum
value, then what will happen, will the session fail? If it is the
situation, then what should be done so that we can stop this kind
of situation in advance?
- 7 Answers
- 13002 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / shridhar
We can use one more sequence generator after that sequence
generator or get the value of max key in unconnected lookup
tx and call that value in expression tx and add +1 to the
value and send to the next tx.
Thanks
Shridhar
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the data movement modes in informatica?
What is the meaning of up gradation of repository?
What are multi-group transformations?
How to improve the performance of a session using sorter transformation?
How many ways are there to create ports?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
How to elaborate powercenter integration service?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What you know about transaction control transformation?
What are the components of workflow manager?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you convert single row from source into three rows into target?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the session task and command task?
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
