I am having source
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
Target
ENO ENAME LOC
1 A PUNE
2 B MUMBAI
3 C CHENNAI
If a new record coming from source from same location it should directly go to specified location in target at begining
EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
- 5 Answers
- 9056 Views
- Polaris, Zensar, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / govind
src_qlr--> sorter(on basis of location)->expression
in exp there will be following ports
1)ENO(I/O)
2)ENAME(I/O)
3)LOC(I/0)
4)V_LOC(VARIABLE PORT) = IIF(LOC = V_PREV_LOC,V_LOC || '|' || LOC,LOC)
5)V_PREV_LOC(VARIABLE PORT) = LOC
6)O_LOC(O/O PORT) = V_LOC
now connect this exp to targert
as
eno to eno
ename to ename
o_loc to loc
| Is This Answer Correct ? | 3 Yes | 2 No |
Answer / babu
what about ENO AND ENAME VALUES,
its should be old values or new values?
please give your output data sample exactly what you need.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajesh aitha
We should ask a question here, do u want the location appended or the rest of the field appended to target if a record with same location is arrived next time?
sort based on location, Next use the logic in expression transformation to check the previous record location and next record location, if same then out put the concatenated values with first answer logic as explained here. Apply the same if required for rest of the fileds.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / krishna
This is wrong question.please explain question with right
information
| Is This Answer Correct ? | 0 Yes | 2 No |
Can we create a Integration service without a Repository service and vice versa?
what is difference between COM & DCOM?
Can I create one wrkflw which will run different wrkflws on schedule time?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
What is synonym?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Teradata 
