Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7356 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Does an informatica transformation support only aggregate expressions?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the surrogate key?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is intricate mapping?
What is a grid in Informatica?
How many dimensions are there in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is a node in Informatica?
what is diff b/t sorter t/r and agg have the option sorter property...
What is the format of informatica objects in a repository?
