How to load Session Statistics (Workflow name, TgtRows,
Rejected Rows, SessStartTime,SessEndTime..)into a database
table ?? Another Question: I want to pass values from
oracle table or Flat file in Mapping parameter/Variable..
What is the method for that..Please provide me the solution
step by step
Answer / akash
There are 2 questions:
1. To load session statistics:
For this we can use 2 concurrent sessions.
Session 1 --> Session 2
The condition for session 2 will be 'Session 1 Status =
Succeeded'.
The source file in the mapping corresponding to session 2
will be the log file of session 1 and output file will have
the desired results.
Question2: How to pass values from oracle table into
mapping parameters or variables?
Frankly speaking, I have no idea of doing this as I have
passed values from the parameter file.
But in case we need the values from oracle table only then
we can create a variable port in an expression and do a
look up on the oracle table.
Since we need this value only once we can use a condition
in expression for using look up only once.
Another alternative is to take the value for this port
right from the source qualifier as an additional port.
Is This Answer Correct ? | 2 Yes | 3 No |
how do u decide whether u need to do aggregations at database level or at Informatica level?
What are the etl testing operations includes?
what happens if the info.server doesn't find the session parameter in the parameter file?
What is ROWID explain ?
SCD2 will work on only dimension tables as well as fact Table?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
0 Answers IBM, Saama Tech, Wipro,
what is session partitioning?
What are the differences between sql override and update override?
List few etl bugs?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what is a parameter when and where do u them when does the value will be created. Designing time, run time. If u don't create parameter what will happen?
Two different admin users created for repository are________and_________.