Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle changing source file counts in a mapping?
- 3 Answers
- 19303 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priyank
We can use an aggregator. Dont to group by on any of the
columns. Add one extra output port for Count. This port
will give the total count of the records in the source file.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / azhar
Simple use v_port in Expression
v_port=0
v_port=v_port+1
for source file record count
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / suresh
we can maintain versions depends upon changes of sourece
file requirement
our current version is running source 1.1.0.0
if we have minor chages 1.1.0.1
if we have mazor chages 1.2.0.0
| Is This Answer Correct ? | 3 Yes | 5 No |
What is the difference between a connected look up and unconnected lookup?
Different qualification between a related rotate toward the sky and isolates look upward?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
What is target load order?
Design a mapping to load a target table with the following values from the above source?
What is degenerated dimention table?
In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the difference Between Mapping parameter and variable
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
Can we use the mapping parameters or variables created in one mapping into another mapping?
Teradata 
