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

Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com

0 Answers  

what is mystery dimension?

1 Answers  

how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,

What is the Hierarchy of DWH?

1 Answers  

Do you find any difficulty while working with flat files as source and target?

0 Answers  




what is the Default Source Option For Update Strategy Transformation?

0 Answers   Informatica,

What is a data modeling?

2 Answers  

what is difference between mapping and mapplet ?

2 Answers   TCS,

how can import the data from the flat files?

2 Answers  

what is the size of u r project? and what is the size of source file?

1 Answers   HP,

what is distinct

4 Answers  

I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.

5 Answers   BirlaSoft,

For more Informatica Interview Questions Click Here
Categories