Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7743 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 |
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What is granularity? Please explain with example
What are cubes and olap cubes?
What are your responsibilities as an etl tester?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
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 are the concerns of OLTP and DSS systems?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
what is session partitioning?
what are business components in Informatica?
how do u decide whether u need to do aggregations at database level or at Informatica level?
what is the meaning of upgradation of Repository?
Teradata 
