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
- 6463 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / babu
Hi Frnds,
by using aggregator we can achieve this,the mapping is have
two pipelines which is shown like bellow.
Mapping:
=======
SRC==>SQ==>EXP==>AGGR==>JNR==>TRG
|| ||
EXP1=========>
AGGR: GROUP BY ALL PORTS AND OUPUT PORT IS REPEAT=COUNT(ID)
JNR:JOIN THE TWO PIPELINES BY USING ID FROM AGGR AND EXP1 .
AGGR:
ID NAME REPEAT(OUTPUT PORT)
1 X 2
2 Y 2
JNR:ID=ID
OUTPUT OF THE JOINER IS
ID NAME REPEAT
1 X 2
1 X 2
2 Y 2
2 Y 2
TRG:
ID NAME REPEAT
1 X 2
1 X 2
2 Y 2
2 Y 2
| Is This Answer Correct ? | 6 Yes | 3 No |
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u
Briefly describe lookup transformation?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.
Is snow flake or star schema used? If star schema means why?
how to run 2 workflows sequentially. plz respond what is the process?
How do you remove duplicate records in informatica?
A Main workflow "wkf_Main" has multiple sessions (S1, S2...., can I make changes and promte one session (S5) at any time or have to promote whole Workflow "wkf_Main" every time?
S1 is having 1 lakh records and s2 is having 100 records, s2 should compare s1 if emp no is same data should be updated if not their it should insert the data.what are the transformation used?
How can you run a session without using server manager?
Teradata 
