Interested to Buy Any Domain ? << Click Here >> for more details...
suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
- 4 Answers
- 11196 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / leo gilbert
Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / vivekk
Src-->SQ-->AGG-->RTR--->TG1 & TG2
In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / laksh
You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.
| Is This Answer Correct ? | 2 Yes | 2 No |
What is deployemnt groups, Lables, query and dynamic deployment group.
What is an MDDB? What is the difference between MDDBs and RDBMSs?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Which kind of index is preferred in DWH?
What is workflow? What are the components of workflow manager?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS
What is an active transformation?
how we can load rejected record's at run time?(not through bad files)
In a concurrent batch if a session fails, can you start again from that session
Can we use unconnected lookup as dynamic lookup?
5 Answers ITC Infotech, TCS, Wipro,
Hi Experts, Performance Wise Which transformation is better in LOOKUP AND JOINER TRansformations? Why? Can anybody please explain it ? Please help me out from this Question. Thanks In Advance.
Teradata 
