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
- 7831 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 u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
What is partitioning? Explain about round-robin, hash partitioning.
what happens if the info.server doesn't find the session parameter in the parameter file?
Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)
What is partitioning? Explain different types of partitioning?
what is data modeling?
What exact we can see in table?
What is a mapping?
How to fine tune mappings?
what are the production issues in datastage?
What is granularity? Please explain with example
how do use session mapping parameters ?(in which transformation)
Teradata 
