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
- 1 Answers
- 7449 Views
- I also Faced
- E-Mail Answers
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 |
what is the main role of FI on business
Mention few test cases and explain them?
Is apache nifi an etl tool?
What is partitioning? Explain about round-robin, hash partitioning.
Hi, Lookup() is what kind of join ?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
what are the facilities provided by OLAP to analytical users?
what is different between sequential batch and concurrent batch and which is recommended and why?
Hi, Urgent recruitment in CTS for informatica ETL .Experience 3 to 10 years.
you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what do u do when DB time takes more?in sap bi
Teradata 
