Source and Target are flat files, Source table is as below
ID,NAME
1,X
1,X
2,Y
2,Y
On Target flat file i want the data to be loaded as
mentioned below
ID,NAME,REPEAT
1,X,2
1,X,2
2,Y,2
2,Y,2
How to achieve this, Can i get a map structure
- 2 Answers
- 6449 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / santa
SRC->SQ->SRT->AGG
JNR TAR
SRC->SQ->SRT->EXP->
AGG INPUT/OUPUT-> ID
AGG VARIABLE/OUTPUT->COUNT(ID)
JNR COND:- ID1=ID
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are batches?
What is the procedure for creating independent data marts from informatica 7.1?
what are the Methods For Creating Reusable Transformations?
What are the differences between oltp and olap?
Describe the impact of several join conditions and join order in a joiner transformation?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Explain pushdown optimization and types in informatica
Could you explain what is enterprise data warehouse?
How can you generate reports in informatica?
What is a repository? And how to add it in an informatica client?
What is a shortcut and copy in Informatica and how two are different with each other?
How to update source definition?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Can informatica load heterogeneous targets from heterogeneous sources?
