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 Posted / 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 |
Post New Answer View All Answers
What are the various tools used in etl?
Is apache nifi an etl tool?
What is tracing level? How many types of transformations supported by sorted input?
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?
How to delete data which is not in source table?
how do u really know that paging to disk is happening while u are using a lookup transform?
What are the modules in Power Mart?
can be used COM component in Informatica ?
what are the concerns of OLTP and DSS systems?
what is the difference between cardinality and Nullability?
Difference between flat files and relational sources?
Mention few test cases and explain them?
Difference between flat files and relational sources?
How to increase performance without changing anything in mapping.( In prod)