1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / mdyaseen.info

Answers were Sorted based on User's Feedback



I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PU..

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

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PU..

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

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PU..

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

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PU..

Answer / ankit kansal

please elaborate your question...

Is This Answer Correct ?    2 Yes 3 No

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PU..

Answer / krishna

This is wrong question.please explain question with right
information

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Informatica Interview Questions

Partition, what happens if the specified key range is shorter and longer

0 Answers   Cap Gemini,

What is the function of look up transformation?

0 Answers  

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

what are the types of facts with Examples?

3 Answers  

What are the scheduling options to run a sesion?

2 Answers  




What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

How do you recover rows from a failed session

1 Answers  

Which one is better performance wise connected/un-connected lkp?why?

2 Answers   HCL, TCS,

define galaxy repository in informatica

0 Answers  

For more Informatica Interview Questions Click Here
Categories