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
- 7814 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 cube grouping?
what is the difference between normal & bulk loading? and which one is recommended ? why?
Do we need an ETL tool? When do we go for the tools in the market?
What is tracing level?
how to load the data to fact table?
What is a staging area? What is the purpose of a staging area?
what is the meant by Normalization and de-normalization?
What are the key benefits of ETL Testing?
What is lookup table in etl testing?
what is HISTOGRAM? how to generate statistics?
architural difference between 7.1 workflow monitor and 8.1 workflow monitor.
how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance
Teradata 
